Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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?