topic Re: Exporting Charts to Excel in QlikView

Exporting Charts to Excel

Thu, 23 Oct 2014 11:48:24 GMT

Hi guys,

is there any possibility to export charts to Excel so that it is showing the chart itself, not the values?

Thanks,
Lina

Re: Exporting Charts to Excel

markodonovan — Thu, 23 Oct 2014 12:01:24 GMT

Hi Lina,

The simple way is to right click on the chart -> copy to clipboard -> then select image or object. Then paste it into an excel document.

Thanks

Mark

http://www.techstuffybooks.com

Re: Exporting Charts to Excel

its_anandrjs — Thu, 23 Oct 2014 12:09:34 GMT

In place of exporting to excel print it as PDF and then save it as Pdf reports. Also you can use the reports wizard if want to print any chart as report.

Regards,

Anand

Re: Exporting Charts to Excel

m_woolf — Thu, 23 Oct 2014 12:31:20 GMT

This can be done by a macro if using the IE plugin.

Search the community for details.

Re: Exporting Charts to Excel

prashantbaste — Thu, 14 Apr 2016 05:29:29 GMT

Hi Lina

I know its too late to reply on this post, but might be helpful for others -

Try below macro -

Sub ExportToExcel

SET XLApp = CreateObject("Excel.Application")

XLApp.Visible = False

SET XLDoc = XLApp.Workbooks.Add

Set objWorkSheet = XLDoc.Sheets.Add

SET XLSheet1 = XLDoc.Worksheets(1)

SET XLSheet2 = XLDoc.Worksheets(2)

SET DB = ActiveDocument.GetSheetByID("SH01")

'DASHBOARD CHARTS

XLSheet2.Name = "Dashboard Tab"

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

XLSheet3.Paste

ExcelFileName = "D:\Excel\QVReportChartsExport" & ".XLS"

XLApp.ActiveSheet.SaveAs (ExcelFileName)

msgbox("Report Exported to Excel at " & ExcelFileName)

XLApp.Visible = True

End Sub

This will store QV Charts as Bitmap image (picture) into Excel.

Regards,

Prashant P Baste

Re: Exporting Charts to Excel

HirisH_V7 — Thu, 14 Apr 2016 06:58:40 GMT

Hi,

In internet Explorer -> By Making Preferred Client as Internet Explorer plugin

Then right click bar chart object-> Copy to Clipboard ->and paste it on excel.

HTH,

Hirish