Export Pie Chart to HTML

[#1]

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

[rwunderlich · Accepted solution]

For the graphics, see the API member "ExportBitMapToFile".

-Rob

[hectorgarcia]

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

[#4]

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,

[#5]

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