topic Re: Store data into an xslx file in QlikView

Store data into an xslx file

Wed, 25 Nov 2020 16:16:04 GMT

I want to store data from a resident table to a xslx file.

How can I go about doing that? I want to do this process when I run the Qlikview itself and not export to xls.

Re: Store data into an xslx file

susovan — Fri, 15 Jul 2016 12:17:05 GMT

Hi Ronak,

Please find the attachment,

Re: Store data into an xslx file

mclen_vj — Fri, 15 Jul 2016 12:17:12 GMT

As part of your script you can store into csv file and open in excel.

e.g.

Store A into A.csv(txt);

-VJ

Re: Store data into an xslx file

Fri, 15 Jul 2016 12:20:03 GMT

This is VB Script. I am looking for Qlikview code such as STORE function to be able to export into excel from the QV script

Re: Store data into an xslx file

Frank_Hartmann — Fri, 15 Jul 2016 12:28:04 GMT

This might be helpful:

Can I use the script to store into xlsx?

Re: Store data into an xslx file

susovan — Fri, 15 Jul 2016 12:28:26 GMT

Hi Ronak,

You can also try this,

Table:

LOAD * INLINE [

ICODE

];

STORE Table into 'D:\PERSONAL\Qlik Community\' Icode.xlsx;

Re: Store data into an xslx file

susovan — Fri, 15 Jul 2016 12:41:44 GMT

Try this script,

Table:

LOAD * INLINE [

ICODE

];

STORE Table into 'D:\PERSONAL\Qlik Community\' Icode.xlsx;

Re: Store data into an xslx file

Fri, 15 Jul 2016 12:45:59 GMT

This doesn't work. It saves it as an xlsx but on trying to open the file - I get the message that file is corrupt or saved in incorrect format

Re: Store data into an xslx file

edddddy24 — Tue, 08 Aug 2017 15:27:10 GMT

Hi.

Unfortunately, QV just store QVD,TXT or CSV files. Here some help text from QV:

A QVD or a CSV file can be created by a store statement in the script. The statement will create an explicitly named QVD or CSV file. The statement can only export fields from one logical table. The text values are exported to the CSV file in UTF-8 format. A delimiter can be specified, see Load. The store statement to a CSV file does not support BIFF export.

store[ *fieldlist from] table into filename [ format-spec ];

*fieldlist::= ( * | field ) { , field } ) is a list of the fields to be selected. Using * as field list indicates all fields.

field::= fieldname [as aliasname ]

fieldname is a text that is identical to a field name in the table. (Note that the field name must be enclosed by straight double Quotation Marks in Scripting or square brackets if it contains e.g. spaces.)

aliasname is an alternate name for the field to be used in the resulting QVD or CSV file.

table is a script labeled, already loaded table to be used as source for data.

filename is the name of the target file. The interpretation of file name is similar to names in load statements, i.e. the directory statements apply.

format-spec ::= ( ( txt | qvd ) )

The format specification consists of a the text txt for text files, or the text qvd for qvd files. If the format specification is omitted, qvd is assumed.

Examples:

Store mytable into xyz.qvd (qvd);

Store * from mytable into xyz.qvd;

Store Name, RegNo from mytable into xyz.qvd;

Store Name as a, RegNo as b from mytable into xyz.qvd;

store mytable into myfile.txt (txt);

store * from mytable into myfile.txt (txt);

(The two first examples have identical function.)