Export to Excel by script with Qlik Sense

[Anonymous]

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

[Frank_Hartmann]

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]

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

[Frank_Hartmann]

no, not possible!

only csv, txt and qvd!

[poojapalni1]

Its possible to extract into excel format 

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

This works

[Wlad_Masi]

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