Re: qlik sense exporting pivot table to excel file with look & feel
I've not yet tried pulling a Pivot Table into Sense, so I'm not sure how it will render. I would certainly look into whether the look of what it provides will meet you needs before exploring further.
I've also not used the On Demand feature against Sense yet. With QlikView though you have a button embedded into the QlikView app which then causes the NPrinting report to be created in the background (with the current selections) on being clicked.
Again, you would need to look into what is available with regards to On Demand in Sense.