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