Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to excel the same format of "SendToExcel" in a Excel File by macro

Hi,

I should create a file Excel by macro with two Sheets.

in the firs sheet i should put the one Pivot Table(with more subtotal lines) wihile, in the second sheet,I need to put the current selection.

No problem for the second sheet (current selection) but I have some problems with first sheet:

The client want to have the same format that he have when click on XLS export Button on the grid.

So, is possible to export the table in the sheet first sheet with the same format of the function SendToExcel?

many thanks and best regards 😄

0 Replies