topic Re: Export table object in EXCEL format in QlikView

Export table object in EXCEL format

agni_gold — Fri, 03 Jan 2014 06:52:09 GMT

I have tried many macros for this , but all these macros not working please help .

I have tried

SUB export

set obj = ActiveDocument.GetSheetObject("TB01")

obj.exportBiff "C:\Documents and Settings\596732\Desktop\manasvi\abc.xlsx";

end sub

call export;

compiler not processing

obj.exportBiff "C:\Documents and Settings\596732\Desktop\manasvi\abc.xlsx";

Re: Export table object in EXCEL format

stevedark — Fri, 03 Jan 2014 11:06:46 GMT

Hi Agnivesh,

Where are you calling the 'call export;' statement? If it is during reload the screen objects are not at that point rendered so can not be accessed.

I would suggest that you test your macro by assigning a call to it as an action on a button. If this works you could look at triggering on Post Reload.

Please see my response on this other thread for more details:

http://community.qlik.com/message/443676#443676

Steve

Re: Export table object in EXCEL format

Clever_Anjos — Fri, 03 Jan 2014 11:26:39 GMT

Objects (tables, graphs) are not available at script time.

You can use an action of type external attached to OnReload trigger

Re: Export table object in EXCEL format

svsudhakar — Fri, 03 Jan 2014 11:47:28 GMT

Hi,

Please create the trigger for calling the macro on post loading.

Settings-->Doc properties--:Add -->Run Macro-->Provide the Macro name

In Edit Module write the below macro code.

sub Export

set obj1 = ActiveDocument.GetSheetObject("CH01")

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

msgbox("Done")

end sub

Regards,

sudhakar