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: 
Not applicable

Export Sheet objects to excel as images without writing macro

Hi all,

swuehladamdavi3sstevedarkvishsaggi

  Need to export all sheet objects in document to an excel sheet as images without writing macro, is it possible

plz guide me

thanks,

swathi

6 Replies
adamdavi3s
Master
Master

This is not possible without a macro I am afraid.

However, we had a similar situation where we wanted a lot of figures exported in one go, without a macro, so I came up with this KPI type report which does the job:

http://qlikanddirty.com/2017/01/06/custom-kpi-report-using-excel-template-and-variables/

karthiksrqv
Partner - Creator II
Partner - Creator II

The only way you can do it without a macro is to use the 'File > Export > Export Sheet Image' using Qlikview Desktop. You'd have to manually do this for each sheet.

PrashantSangle

As Karthik suggested you can manually do it by

right click on chart > copy to clipboard > image

then paste it into excel

or

Use NPrinting tool.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Hi adam,

Thank you for fast response ,but i am unable to open that link .

Thanks,

Swathi

adamdavi3s
Master
Master

I also posted on the community thankfully (I chose a stupid name for my blog)

Custom KPI Report Using Excel Template and Variables

Not applicable
Author

Hi Adam,

Now it has opened

thank you very much

Thanks,

Swathi