topic export chart to XL file?? in QlikView

export chart to XL file??

sushil353 — Wed, 07 Dec 2011 07:45:59 GMT

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

export chart to XL file??

Wed, 07 Dec 2011 07:51:18 GMT

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

sushil353 — Wed, 07 Dec 2011 07:58:35 GMT

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

SunilChauhan — Wed, 07 Dec 2011 07:59:35 GMT

sub abc

SET obj = ActiveDocument.GetsheetObject("Ch01")

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

end sub

export chart to XL file??

Wed, 07 Dec 2011 08:05:50 GMT

Yes,

It the same that Sunil Chauhan has told you.

Regards,

Nitin Jain

export chart to XL file??

rwunderlich — Wed, 07 Dec 2011 08:50:14 GMT

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