Store data into an xslx file

[#1]

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.

[susovan]

Hi Ronak,

Please find the attachment,

[mclen_vj · Accepted solution]

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

e.g.

Store A into A.csv(txt);

-VJ

[#4]

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

[Frank_Hartmann]

This might be helpful:

Can I use the script to store into xlsx?

[susovan]

Hi Ronak,

You can also try this,

Table:

LOAD * INLINE [

ICODE

A

B

C

D

E

];

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

[susovan]

Try this script,

Table:

LOAD * INLINE [

ICODE

A

B

C

D

E

];

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

[#8]

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

[edddddy24]

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.)