Export Charts (Tables/Graphs) into Folder - as .jpeg

[guytzumer]

Hallo Qommunity

I need to Export Tables/Graphs into folder (in jpeg format) on the scheduled reload

Does anybody have a macro or exmple to export Charts (Tables/Graphs) into folder as .Jpeg file ??

Thanks in advance

Guy.

[guytzumer · Accepted solution]

Well, find the solution for that problam

it was pretty easy

this example is for export a Sheet & a Graph

to make it over night running - jest to tie it to "OnPostReload"

sub exportToFolder

GraphPath = "C:\qlikview\"

ActiveDocument.Sheets("Main").ExportBitmapToFile GraphPath & "A.jpg"

ActiveDocument.GetSheetObject( "CH01").ExportBitmapToFile GraphPath & "B.jpg"

ActiveDocument.GetSheetObject( "CH02").ExportBitmapToFile GraphPath & "C.jpg"

end sub

Guy

[jagannalla]

Hi,

Whether this code works at access point. Write now i don't have test machine to test this code in webview.

[monika_armonika]

The macro runs for me but the folder stays empty. I have created a button and I am able to push it, mouse arrow becomes a turning wheel for a bit etc. 

Steps: I have allowed system access in edit Module.

I have verified the correct id of the graph

I have created the folder where the graph should be saved. Is it possible that I have a problem in my settings? QlikView version: 12.10. Microsoft office (if relevant): 365.  

I would really appreciate your help.