export chart to XL file??

[sushil353]

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..

Thanks

Sushil

[#2]

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

[sushil353]

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

[SunilChauhan]

sub abc

SET obj = ActiveDocument.GetsheetObject("Ch01")

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

end sub

[#5]

Yes,

It the same that Sunil Chauhan has told you.

Regards,

Nitin Jain

[rwunderlich]

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