Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gbovini
Contributor II
Contributor II

ExportBiff

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

1 Solution

Accepted Solutions
gbovini
Contributor II
Contributor II
Author

Hi Sparur,

thanks, my mistake was just in the syntax.

I checked and now everything is ok.

thanks again, Gianni


View solution in original post

3 Replies
sparur
Specialist II
Specialist II

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
Contributor II
Contributor II
Author

Hi Sparur,

thanks, my mistake was just in the syntax.

I checked and now everything is ok.

thanks again, Gianni


Jayabal1987
Contributor
Contributor

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