Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi,
Whether this code works at access point. Write now i don't have test machine to test this code in webview.
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.