4 Replies Latest reply: Apr 17, 2009 8:04 PM by AlfredoSanchez RSS

    Export Pie Chart to HTML

      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

        • Export Pie Chart to HTML
          Rob Wunderlich

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

          -Rob

          • Export Pie Chart to HTML
            HECTOR GARCIA

            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