Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need store into XLS File., to import in tasks.
The file have 3 sheets:
check with this code
https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784
Vikas
Hi,
I need store in a file, not Load from xls
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.
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.
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?
Hello,
I think it is not possible to store directly into XLSX format via store script, only in CSV, as mentioned in the doc:
Store command doesn't accept other format than QVD, TXT, or CVS, that's why biff or openxml keyword is not accepted.
Best regards