topic Re: Export Sheet objects to excel as images without writing macro in QlikView

Export Sheet objects to excel as images without writing macro

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

swuehl‌adamdavi3s‌stevedark‌vishsaggi‌

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

Re: Export Sheet objects to excel as images without writing macro

adamdavi3s — Thu, 30 Mar 2017 08:18:48 GMT

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/

Re: Export Sheet objects to excel as images without writing macro

karthiksrqv — Thu, 30 Mar 2017 08:22:34 GMT

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.

Re: Export Sheet objects to excel as images without writing macro

PrashantSangle — Thu, 30 Mar 2017 08:26:33 GMT

As Karthik suggested you can manually do it by

right click on chart > copy to clipboard > image

then paste it into excel

Use NPrinting tool.

Regards

Re: Export Sheet objects to excel as images without writing macro

Thu, 30 Mar 2017 09:23:49 GMT

Hi adam,

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

Thanks,

Swathi

Re: Export Sheet objects to excel as images without writing macro

adamdavi3s — Thu, 30 Mar 2017 09:25:49 GMT

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

Custom KPI Report Using Excel Template and Variables

Re: Export Sheet objects to excel as images without writing macro

Thu, 30 Mar 2017 10:12:31 GMT

Hi Adam,

Now it has opened

thank you very much

Thanks,

Swathi