storing data to xls format

[thomaswrieck]

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]

Dear Friend

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

Regards

Sunil Jain.

[thomaswrieck]

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

[#4]

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