How to store into XLS?

[leonardo_sudo]

Hi all,

I need store into XLS File., to import in tasks.

The file have 3 sheets:

[vikasmahajan]

check with this code

https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784

Vikas

[leonardo_sudo]

Hi,

I need store in a file, not Load from xls

[Keitaru]

XLS:

store <tablename> into <ExcelName> (biff, embedded labels, table is [SheetName]);

xlsx:

store <tablename> into <ExcelName> (ooxml, embedded labels, table is [SheetName);

These worked for me.

[leonardo_sudo]

😞
Thosen't worked for me.

[bl1]

Hi,

I also need to store into XLSX from data load editor and not succsed with the kod up.

do someone has another idea ?

thanks.

[LucasCarvalho]

Hi Leonardo, I have this same issue...

Need to store a xlsx file with 3 sheets and later import a task in the Nprinting!

How did you solved? Do you remember?

[Anonymous]

Hello,

I think it is not possible to store directly into XLSX format via store script, only in CSV, as mentioned in the doc:

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

Store command doesn't accept other format than QVD, TXT, or CVS, that's why biff or openxml keyword is not accepted.

Best regards