Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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/
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.
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
Hi adam,
Thank you for fast response ,but i am unable to open that link .
Thanks,
Swathi
I also posted on the community thankfully (I chose a stupid name for my blog)
Hi Adam,
Now it has opened
thank you very much
Thanks,
Swathi