Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-04-04 05:08 AM

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 😄

577 Views
0 Likes
0 Replies