5 Replies Latest reply: Dec 7, 2011 3:50 AM by Rob Wunderlich RSS

    export chart to XL file??

    Sushil Kumar

      Hi All,

       

      There is a line chart in my dashboard. when i use export to xl, it shows related data into xl in table format....

       

      But i want to show the graph in the xl...

       

      how can i achieve this...

       

      Please help me out to solve this issue..

       

      untitled.JPG

       

      Thanks

      Sushil

        • export chart to XL file??

          If you are using the Qlikview IE Plugin then

          Right Click on the chart

          Copy to clipboard--> Images

          Then Paste it in the Excel.

           

          and if you are using the Qlikview AjaxZFC then

           

          Right Click on the chart

          Print--> New window will popup--> copy that image and paste in the excel.

           

          And if you are using the Qlikview Developer Client then it same as of Qlikview IE Plugin.

           

          Regards,

          Nitin jain

            • export chart to XL file??
              Sushil Kumar

              Hi Nitin,

               

              Thanks for ur reply...

               

              Can't we provide a button so that the image can export directly to xl...

               

              Like we import tables to XL

               

              Thanks

                • export chart to XL file??

                  Yes,

                  It the same that Sunil Chauhan has told you.

                   

                  Regards,

                  Nitin Jain

                  • export chart to XL file??
                    Rob Wunderlich

                    I can suggest a number of approaches.

                     

                    1. Get the QvExcel product http://www.qvexcel.com/

                     

                    2. Export the file to a known location as Sunil suggested and use a link in the spreadsheet to reference the file. I don't think this will work in the Ajax client.

                     

                    3. Use a button to launch a macro like below. I don't think this will work in Ajax.

                     

                    Sub InsertPicture

                              set obj = ActiveDocument.GetsheetObject("CH01")

                              filePath = GetTempPath & "\picture.bmp"  

                      obj.ExportBitmapToFile filePath

                     

                              Set objExcel = CreateObject("Excel.Application")

                              objExcel.Visible = True

                              Set objWorkbook = objExcel.Workbooks.Add

                              Set objWorksheet = objWorkbook.Worksheets(1)

                              objWorksheet.Pictures.Insert (filePath).Select

                     

                              REM Delete the picture file

                              Set objFSO = CreateObject("Scripting.FileSystemObject")

                              objFSO.DeleteFile(filePath)

                    End Sub

                     

                    Function GetTempPath

                              CONST TemporaryFolder = 2

                              Set objFSO = CreateObject("Scripting.FileSystemObject")

                              GetTempPath = objFSO.GetSpecialFolder(TemporaryFolder).Path

                    End Function

                     

                     

                    -Rob

                    http://robwunderlich.com

                • export chart to XL file??
                  Sunil Chauhan

                  sub abc

                  SET obj = ActiveDocument.GetsheetObject("Ch01")

                              obj.ExportBitmapToFile "C:\Temp\"& replace(obj.GetCaption.Name.v," ","") & ".bmp"    

                  end sub