topic Re: 'XLS' Format of Export in QlikView

'XLS' Format of Export

Tue, 23 Jun 2015 09:30:00 GMT

Hi,

I am trying to pre define the file name and path of the table to be excel exported.

I am able to achieve this with the piece of macro code below, but even with '.xls' specified, the file exported is a '.csv' format file !

Sub ExportExcelTable

set obj = ActiveDocument.GetSheetObject("TB01")

File = "C:\Users\Documents\Table1.xls"

obj.SaveAs= "C:\Users\Documents\Table1.xls"

obj.ActiveWorkbook.Save

Appreciate any help on the same.

Thanks.

Re: 'XLS' Format of Export

MayilVahanan — Tue, 23 Jun 2015 09:36:59 GMT

If your data is huge, then automatically its save in CSV file format.

Edit:

Try to save in xlsx file format.

Hope it helps

Re: 'XLS' Format of Export

Tue, 23 Jun 2015 09:46:07 GMT

Thanks for the reply.

The data to be exported is not huge at all.

Unfortunately, the code I am using doesn't work for '.xlsx' format (it opens the edit module on clicking of the action button !)

any clue ?

Re: 'XLS' Format of Export

MayilVahanan — Tue, 23 Jun 2015 09:51:21 GMT

Please refer

Export to XLSX

Re: 'XLS' Format of Export

balasundaram — Tue, 23 Jun 2015 09:51:50 GMT

Hi,

Use below code for export to csv.

sub ExportCSV()

set obj1=ActiveDocument.GetSheetObject("CH01")

obj1.Export "C:\new.csv" , ","

end sub

give ur object id and path on BOLD letters

Regards,

Bala