How to give sheetname while storing table in xls/csv format

[swat_agar]

Hi,

Can anyone help me with the below case -

I have loaded a web file in my Qlikview script and I have to store that as an excel file. The below statement gives the sheet name same as the file name.

Store XYZ into XYZ.csv(txt);

Is there any way by which I can specify the sheet name as I have to store multiple tables in different tabs of same file?

Thanks.

[nevilledhamsiri]

Go to sheet properties & then on the title row define the required name. Like wise by adding any number of sheets you could go on typing the name required.

[swat_agar]

Thanks for you response but I need to do it in a qlikview script via a code and not manual process. Whenever I run the QV script, it should store it in a file with the specified tab name. And FYI, I want to change the tab name of excel file and not the sheet in Qlik frontend.

[marcus_sommer · Accepted solution]

Natively it's not possible to store data into a xlsx. Possible would be to export/copy these data per macro from the UI and there are also posibilities to automate such a task. Depending on your data and environment it's more or less sophisticated. Within the community are various postings to these topics. Nevertheless it might be easier and cheaper to use a specialized tool like NPrinting.

More easy could be just to output all the data into the various csv-files and to pull them with an excel-macro into your target-file or maybe just using them as an external data-source in excel.

- Marcus