topic Re: ExportBiff in QlikView

ExportBiff

gbovini — Tue, 22 Jun 2010 05:30:32 GMT

Hi !

i've ver. 9.0 SR3

I would like to export in excel a table, and this istructions give error.

set obj = ActiveDocument.GetSheetObject("table name")

obj.ExportBiff("c:\Programmi\QlikView\Test.xls") or obj.Export "C:\Programmi\test.csv",","

suggestions ?

regards

sparur — Tue, 22 Jun 2010 07:11:24 GMT

Hello, Gianni.

What is "table name" ?

You should pass in GetSheetObject() object ID, NOT table name or anything else...

for example:

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff("c:\Programmi\QlikView\Test.xls")

gbovini — Tue, 22 Jun 2010 08:05:16 GMT

Hi Sparur,

thanks, my mistake was just in the syntax.

I checked and now everything is ok.

thanks again, Gianni

Jayabal1987 — Tue, 30 Apr 2019 18:59:03 GMT

set obj = ActiveDocument.GetSheetObject("table name")

obj.ExportBiff("c:\Programmi\QlikView\Test.xls")

I used this macro to export the table in excel but i couldn't get output its showing error and in obj its showing Nothing