topic Re: Export Multiple Charts to Excel in QlikView

Export Multiple Charts to Excel

ND1 — Thu, 26 Nov 2020 12:51:38 GMT

Hello,

I'm trying to export 6 line charts to the same excel and sheet, as images.

I tried something like:

sub exportToExcel

Dim aryExport(1,3)

aryExport(0,0) = "CH01"
aryExport(0,1) = "Sales"
aryExport(0,2) = "A1"
aryExport(0,3) = "image"

aryExport(1,0) = "CH02"
aryExport(1,1) = "Sales"
aryExport(1,2) = "A14"
aryExport(1,3) = "image"

Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

end sub

As I read in previous posts, but It didn't work.
I want in the excel the 6 images to be displayed as 2x3.

Re: Export Multiple Charts to Excel

Chanty4u — Thu, 26 Nov 2020 12:56:49 GMT

did you check this

https://community.qlik.com/t5/QlikView-App-Development/How-can-we-export-the-multiple-charts-to-excel-with-an-single/td-p/469628

Re: Export Multiple Charts to Excel

ND1 — Thu, 26 Nov 2020 13:34:20 GMT

Thank you for the reply,

I tried this with the following 2 objects.

by writing:

Sub ExportExcel

SET excelFile = CreateObject("Excel.Application")
excelFile.Visible = true
SET XLDoc = excelFile.Workbooks.Add
SET XLSheet = XLDoc.Worksheets(1)

ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard true
XLSheet.Paste XLSheet.Range("A1")

ActiveDocument.GetSheetObject("CH02").CopyTableToClipboard true
XLSheet.Paste XLSheet.Range("A10")

excelFile.Visible = True
End Sub

And the result is:

Re: Export Multiple Charts to Excel

ND1 — Thu, 26 Nov 2020 14:50:21 GMT

So, among different ways that do work regarding the "export", my main problem is that I don't get images.|

I also tried, as shown in the 1st post, what is described here:
http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

where images are exported, but it didn't work.

I'm not familiar with Macro commands, so I don't really understand what I should write.

Thank you!

Re: Export Multiple Charts to Excel

Lortonnn — Tue, 01 Dec 2020 06:52:02 GMT

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating it. Looking forward for solution

Re: Export Multiple Charts to Excel

ND1 — Tue, 15 Dec 2020 16:59:56 GMT

Hello,

I managed to solve the problem above using the code found in

https://community.qlik.com/t5/QlikView-Scripting/Exporting-multiple-objects-to-multiple-Excel-sheets/td-p/1314211

or in

https://community.qlik.com/t5/QlikView-Documents/Export-Qlikview-objects-to-multiple-Excel-sheet/ta-p/1482334