Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

Store in excel with multiples sheets

Hi guys,

I need to create an excel file by STORE INTO (without macro) with data in different sheets. I have a table and I would like to put in the sheet A data from column A  and sheet B from column B.

Labels (2)
1 Reply
Brett_Bleess
Former Employee
Former Employee

Here is the Help on the Store function, do not believe you can do what you are trying to do with just the Store, likely going to have to use a macro and Excel APIs to do that, or potentially you could look at NPrinting to see if it will do it, but that would be the only other thing of which I can think.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.