Automate the process to export to excel

[prashantsanchet]

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]

Qlik NPrinting is the best approach for this

[prashantsanchet]

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]

I doubt