topic Re: How to store into XLS? in App Development

How to store into XLS?

leonardo_sudo — Fri, 15 Mar 2019 17:33:58 GMT

Hi all,

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

The file have 3 sheets:

vikasmahajan — Mon, 25 Mar 2019 11:05:26 GMT

check with this code

Vikas

leonardo_sudo — Thu, 04 Apr 2019 19:45:46 GMT

Hi,

I need store in a file, not Load from xls

Keitaru — Fri, 05 Apr 2019 04:49:52 GMT

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 — Thu, 16 May 2019 11:43:46 GMT

😞
Thosen't worked for me.

bl1 — Tue, 08 Dec 2020 08:00:56 GMT

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 — Mon, 23 Aug 2021 15:18:11 GMT

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 — Mon, 23 Aug 2021 15:31:00 GMT

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