topic Automate the process to export to excel in App Development

Automate the process to export to excel

prashantsanchet — Fri, 10 Nov 2017 06:56:33 GMT

Hi Team,

I have one requirement in Qlik Sense where i need to automate the process to exporting pivot table data to excel

The Requirement is like

1) Go to Folder

2) Copy Previous Day Excel File

3) Rename the file ()

4) Open the Excel File

5) Clear the Data from Both Tab in Excel File

6) Open QlikSense report having pivot table

7) Export that data into excel automatically

😎 Format that excel

9) Send an Email to user

Could you please provide your input on how we can achieve this using QlikSense.

shraddha_g — Fri, 10 Nov 2017 06:59:51 GMT

Qlik NPrinting is the best approach for this

prashantsanchet — Fri, 10 Nov 2017 07:46:33 GMT

Hi Shraddha ,

Thanks for quick response. But I think NPrinting is not free and It is license one so do you think any other way.

shraddha_g — Fri, 10 Nov 2017 08:25:44 GMT

I doubt