topic storing data to xls format in QlikView

storing data to xls format

thomaswrieck — Tue, 20 Jul 2010 07:40:02 GMT

Hi,

I need to store table data from qlikview to excel (all from script, nothing manual) and I couldn't find a build-in solution for this.

After some investigations the idea I have is to create a table object via a macro (using CreateTable) and store this one to excel using obj.Export.

I'm not familiar with this macro stuff so I would be happy If someone could help me out.

Thanks a lot

Thomas

suniljain — Tue, 20 Jul 2010 08:12:03 GMT

Dear Friend

store * from mytable into myfile.xls (xls);

Regards

Sunil Jain.

thomaswrieck — Tue, 20 Jul 2010 08:26:31 GMT

hmmm ... did you try this ? .... that would be nice If that would work but it doesn't

Tue, 20 Jul 2010 10:11:09 GMT

here is the macro code to export the content of object CH01 to an excel file:

sub exportCH01toExcel
 set obj = ActiveDocument.GetSheetObject("CH01")
 obj.ExportEx "C:\test.xls", 5
end sub