Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
adrianfer
Contributor III
Contributor III

Qlik Sense Mashup - export multiple tables to excel

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.

1 Solution

Accepted Solutions
petter
Partner
Partner

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

View solution in original post

2 Replies
petter
Partner
Partner

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

View solution in original post

shlomoh
Contributor III
Contributor III

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