Qlik Sense Mashup - export multiple tables to excel

[adrianfer]

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.

[petter · Accepted solution]

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 ...

[shlomoh]

You can do this and much more, using LogiExport extension for QlikSense
https://logiexport.logsys.co.il/documentation/
See the "Multiple Objects" section.