Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Adding functionality to macro for Excel export

Hello community,

I'm trying to export charts and tables to Excel with the macro provided in this article:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

'// ****************************************************************

'// Export of multiple objects in different formats (data & image)

'// In one case (sheet "Sales Overview") two objects are placed on

'// one sheet.

'// ****************************************************************

Dim aryExport(4,3)

aryExport(0,0) = "objSalesPerRegion"

aryExport(0,1) = "Sales Overview"

aryExport(0,2) = "A1"

aryExport(0,3) = "image"

The macro works nicely, but I would like to also grab or set the caption of each object for the export so that I can place it above each chart in the Excel document.

I wouldn't mind setting it manually but of course it would be nicer to get the text directly from the caption.

Can I also use a text object and write it in a cell in Excel?

Any ideas how I need to modify above macro to include this functionality?

Thank you,

Thorsten