topic Re: Export table to excel during reload in QlikView

Export table to excel during reload

ankit777 — Fri, 03 Jan 2014 09:25:57 GMT

How can I export a table in Qlik view to excel sheet during reload.?

Re: Export table to excel during reload

sujeetsingh — Fri, 03 Jan 2014 09:27:52 GMT

u can use a macro and call the macro in the script and execute it but may be i am not sure .

Re: Export table to excel during reload

ankit777 — Fri, 03 Jan 2014 09:28:54 GMT

If possible can you give the code for the same?

Re: Export table to excel during reload

brijesh1991 — Fri, 03 Jan 2014 09:37:11 GMT

Write the below macro(Ctrl+M)

-------------

sub Export

set obj1 = ActiveDocument.GetSheetObject("TB01")

obj1.Export "D:\InnerJoin.xls",4

msgbox("Done")

end sub

-----------

Goto Document Properties--->Trigger---->OnPostReload--->Add Action--->Add---> External--->Run Macro---> give macro name(Export)

Re: Export table to excel during reload

ankit777 — Fri, 03 Jan 2014 09:53:13 GMT

I am putting a semi colon after

msgbox("Done")

But the code is not creating any excl sheet.

Also can u tell me the significance of 4 in

obj1.Export "D:\InnerJoin.xls",4

Re: Re: Export table to excel during reload

brijesh1991 — Fri, 03 Jan 2014 10:29:25 GMT

Reload the attached file

Re: Re: Export table to excel during reload

ankit777 — Fri, 03 Jan 2014 10:46:22 GMT

The following code creates the Excel sheet in correct format.

sub Export

set obj1 = ActiveDocument.GetSheetObject("TB01")

obj1.ExportBiff "C:\Documents and Settings\596732\Desktop\manasvi\InnerJoin.xls"

msgbox("Done")

end sub

Re: Re: Export table to excel during reload

brijesh1991 — Fri, 03 Jan 2014 10:51:01 GMT

Cheers!!!!!!!!!!!!!!

Re: Export table to excel during reload

stevedark — Fri, 03 Jan 2014 11:03:21 GMT

Hi Ankit,

You are limited in what you can do during the reload script with regards to firing a macro to write to Excel. Firing a macro like the one above will be fine on post reload - but I'm not sure it will fire correctly if refreshed from QlikView Server.

The simplest way to export data for use in Excel during reload is to do it as a CSV file, a simple store statement can be used to do this:

STORE TableName INTO .\DataFile.csv (txt);

If you want formatted Excel output then you need to look at a product such as NPrinting, which allows you to write to a pre-defined template, with headers, different fonts and multiple tabs.

Please get in touch if you would like more information about NPrinting.

Hope that helps,

Steve

Re: Export table to excel during reload

ankit777 — Fri, 10 Jan 2014 08:27:23 GMT

Hi Steve,

I would like to know more about NPrinting.

Re: Export table to excel during reload

stevedark — Fri, 10 Jan 2014 09:14:15 GMT

Hi Ankit,

There is more information on our website at: http://www.quickintelligence.co.uk/nprinting/

You can also contact me directly through that link and I can send more details, such as licence options and pricing.

Regards,

Steve