Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need export some graphics chart to html document for a customer from a qvw file. Those charts will be diferent every time since the filter that the operator apply for the customer.
I have a Macro where I can export Simple Table and Pivot table to html document, using the command .CopyTabletoClipboard from a Macro.
Somebody know how I can export the graphics in the same way?..
Thanks,
Alfredo
For the graphics, see the API member "ExportBitMapToFile".
-Rob
Hi alfredo, what we do is to have a html template that uses graphics we export from qvw with this macro:
sub Clientes
set obj = ActiveDocument.GetSheetObject("CH183")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Commercebank"
obj.ExportBitmapToFile "C:\QlikView Publisher Data\Private Data\Source Documents\Images\CH183.jpg"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH182")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Commercebank"
obj.ExportBitmapToFile "C:\QlikView Publisher Data\Private Data\Source Documents\Images\CH182.jpg"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH181")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Commercebank"
obj.ExportBitmapToFile "C:\QlikView Publisher Data\Private Data\Source Documents\Images\CH181.jpg"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH186")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Commercebank"
obj.ExportBitmapToFile "C:\QlikView Publisher Data\Private Data\Source Documents\Images\CH186.jpg"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH185")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Commercebank"
obj.ExportBitmapToFile "C:\QlikView Publisher Data\Private Data\Source Documents\Images\CH185.jpg"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH184")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Commercebank"
obj.ExportBitmapToFile "C:\QlikView Publisher Data\Private Data\Source Documents\Images\CH184.jpg"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH225")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Bolp_Co"
obj.ExportBiff "C:\QlikView Publisher Data\Private Data\Source Documents\Images\Report_Bolp_CB_MTD1.xls"
ActiveDocument.GetApplication.Sleep 60000
set obj = ActiveDocument.GetSheetObject("CH225")
ActiveDocument.ClearAll True
ActiveDocument.RecallUserBookmark "Bolp_Co_Mer"
obj.ExportBiff "C:\QlikView Publisher Data\Private Data\Source Documents\Images\Report_Bolp_CB_MTD2.xls"
ActiveDocument.GetApplication.Sleep 60000
end sub
================================================================
saludos
Rob, Thanks a lot for the API Reference, It was great to export one to one the charts.
Now I have to put all the chart in one page.
Best Regards,
This is the final code that I use to send all the Sheet to a jpg file and then to a html page:
sub Export2
set obj = ActiveDocument.ActivateSheet("SH04")
obj.ExportBitmapToFile "C:\temp\Evolucion.jpg"
ActiveDocument.GetApplication.Quit
end sub