topic Re: How to give sheetname while storing table in xls/csv format in QlikView

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

swat_agar — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

nevilledhamsiri — Wed, 16 Sep 2020 18:36:33 GMT

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.

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

swat_agar — Thu, 17 Sep 2020 04:12:37 GMT

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.

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

marcus_sommer — Thu, 17 Sep 2020 07:52:07 GMT

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