Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export to Excel by script with Qlik Sense

Hello everyone,

I want to export my datas to excel by a script. I didn't find anything that helped me. How can i export datas to excel in the dataeditor per code? 

I found this: https://www.youtube.com/watch?v=90XHKSrYN-E but this isn't  with a script. 

Thank you in advance! 

- Steven

 

Labels (3)
5 Replies
Frank_Hartmann
Master II
Master II

try like this:

 

Tmp:
Load *, if(date#(Date1,'YYYYMMDD')-date#(Date2,'YYYYMMDD')>365,'90%','other') as New;
LOAD * INLINE [
    Date1, Date2
    20190911, 20180911
    20190911, 20180411
    20190911, 20180910
];

store Tmp into Test.csv (txt);

 

Note: you can only export to Excel-csv. Other formats are not supported!

 

Anonymous
Not applicable
Author

Thank you for the answer. So it's not possible to store it as a .xls (xlsx,...) file ? 

Frank_Hartmann
Master II
Master II

no, not possible!

only csv, txt and qvd!

poojapalni1
Contributor II
Contributor II

Its possible to extract into excel format 

 

STORE * FROM [NAME] INTO [path/filename.xlsx](txt);

This works

Wlad_Masi
Employee
Employee

Based on our documentation the types of file that you would be able to create are QVD, CSV and TEX as you can see in the statement below.


"The statement will create an explicitly named 
QVD, CSV, or TXT file." 

 

Here is a link for the help page: Store

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.