Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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