topic Exporting background image with data in QlikView

Exporting background image with data

AbhijitBansode — Tue, 08 Jan 2013 14:45:27 GMT

Hi All,

The pivot table background image need to be exported to excel with data.

Default Export to Excel option in Qlikview exports only data.

Can anybody know way to achieve this?

any workaround?

Re: Exporting background image with data

Gysbert_Wassenaar — Tue, 08 Jan 2013 15:00:07 GMT

Export it twice, once as table and once as image. Send to Excel won't do this, you can do it manually with Copy to Clipboard and choose image and then paste it in Excel. Or you can use a macro and use a button to initiate the export macro. Here's an example. And here's a more complex example for exporting multiple charts to excel.

Re: Exporting background image with data

AbhijitBansode — Tue, 08 Jan 2013 15:44:51 GMT

Thanks for reply..

I'm getting the error : "ActiveX component can't create object: 'Excel.Application' "

on line

Set objExcelApp = CreateObject("Excel.Application")

Even if I'm running macro in Allow System Access mode..

What could be the problem?