Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I was wondering if anyone else has found a solution to do this? We wanted to export multiple tables to one excel file, on separate tabs.
Have you had a look at this article?
Qlik Design Blog Export Data, Image and Pdf from Qlik Sense September 2018 Capability API
The "exportData" method supports ooxml as a format which means that modern Excel files can be made. However support for having separate sheets is not there. You will have to do some post-processing to get multiple Excel files to "merge" into one Excel workbook as separate sheets. That can be achieved by an Excel VBA-macro for instance.
Maybe this is what you need or a step towards what you need ...
Have you had a look at this article?
Qlik Design Blog Export Data, Image and Pdf from Qlik Sense September 2018 Capability API
The "exportData" method supports ooxml as a format which means that modern Excel files can be made. However support for having separate sheets is not there. You will have to do some post-processing to get multiple Excel files to "merge" into one Excel workbook as separate sheets. That can be achieved by an Excel VBA-macro for instance.
Maybe this is what you need or a step towards what you need ...
You can do this and much more, using LogiExport extension for QlikSense
https://logiexport.logsys.co.il/documentation/
See the "Multiple Objects" section.