topic Re: Export pictures to Excel in QlikView

Export pictures to Excel

Mon, 12 Dec 2016 11:43:02 GMT

Hi,

I am trying to export a straight table with pictures into excel. Challenge is that picture must be exported in that way, so end user can do filtering in excel on some other fields, and see picture for corresponding row.

Small example is in attach.

Your help is greatly appreciated.

Re: Export pictures to Excel

marcus_sommer — Mon, 12 Dec 2016 14:36:53 GMT

AFAIK this isn't possible. The pictures aren't a real content within the table else the link/url is the content and only while the runtime replaced with the picture. Maybe tools like Qlik NPrinting offer more features. One workaround could be to use excel-macros to convert the link into a picture again.

- Marcus

Re: Export pictures to Excel

Tue, 13 Dec 2016 09:12:52 GMT

I already tried something like that, but I couldn't manage to push excel to open picture URL during document opening.

Re: Export pictures to Excel

marcus_sommer — Tue, 13 Dec 2016 10:59:57 GMT

Take a look on the various office/vba-foren like: https://www.google.de/search?q=vba+embed+image

- Marcus

Re: Export pictures to Excel

Tue, 13 Dec 2016 12:52:25 GMT

I tried many, but it is not working...

Re: Export pictures to Excel

agigliotti — Fri, 26 Apr 2024 10:24:28 GMT

Hi,
Did you find a workaround?