Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AbhijitBansode
Specialist
Specialist

Exporting background image with data

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?

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
AbhijitBansode
Specialist
Specialist
Author

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?