topic Re. :Re: Re. :Re: Export data from QVD file to EXCEL file in QlikView

Export data from QVD file to EXCEL file

Wed, 29 Dec 2010 13:12:15 GMT

Hello community.

I have a problem.

I want to export data from a QVD file to an Excel file automatically.

I would write a script Qikview or a VB macro that does it.

Please i implore your help.

If someone has already done something like that so I listen him

Thank you

Wed, 29 Dec 2010 13:29:44 GMT

If you are using QV9 or later you can use "store" command to write a csv file.

If that is not usefull then you must write a macro.

Steps for the export through macro

1. Load qvd in one qwv file

2. define a table with all the field in the qvd

3. define a macro which must contain:

set obj = ActiveDocument.GetSheetObject("TB01"). "TB01" is the id of the table you created at step 2

obj.ExportBiff "YOUR EXCEL FILE WITH PATH.xls"

4. you must put your macro in the post reload event trigger

Wed, 29 Dec 2010 13:41:39 GMT

This is my macro:

sub export_QVD_to_EXCEL
set obj = ActiveDocument.GetSheetObject("TB01")
obj.ExportBiff "COMPTE.xls"
end sub

but the file COMPTE.xls is not created when i reload my qlikview document

The following message is displayed on the macro windows : Objet requis: 'obj'

and this statement are selected : obj.ExportBiff "COMPTE.xls"

Thanks

Wed, 29 Dec 2010 14:32:32 GMT

it should work. At least for me works. Can you upload an example qwv file?

Wed, 29 Dec 2010 14:39:25 GMT

You can see it in the archive file.

Wed, 29 Dec 2010 14:55:02 GMT

you should do a table box in the interface 😛 not a table in the script :P. Look at the .qwv file i attached.

Wed, 29 Dec 2010 15:10:19 GMT

thanks

it's ok

but can we not do this without displaying the contents of the table?