Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
swat_agar
Contributor
Contributor

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

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.

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

3 Replies
nevilledhamsiri
Specialist
Specialist

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
Contributor
Contributor
Author

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
MVP & Luminary
MVP & Luminary

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