topic Re: Export image from a table to excel in QlikView

Export image from a table to excel

Tue, 23 Feb 2016 10:55:39 GMT

Hello,

I have got a table chart in QV that looks like the following:

Name	Surname	Sales
Jon	Jon	700
Manuel	Popayan	700
Ana	Lalas	800
Marta	Baiao	900

When I try to export to excel, the field photo comes empty. Is there anyway for me to be able to export the images from the table chart to excel?

Thanks in advance for your help!

Iuri

Re: Export image from a table to excel

luciancotea — Tue, 23 Feb 2016 11:01:50 GMT

No, Excel doesn't have that feature.

Re: Export image from a table to excel

Chanty4u — Tue, 23 Feb 2016 11:03:34 GMT

chk dis

Re: Exporting Images To Excel

Re: Export image from a table to excel

ramasaisaksoft — Tue, 23 Feb 2016 11:09:08 GMT

Hi Luri,

It is a Excel format issue

if your images are placed in some folder then you can insert at particular image cell

Go to Insert tab->Click on Picture and provide the path.

Re: Export image from a table to excel

PrashantSangle — Tue, 23 Feb 2016 11:16:42 GMT

Hi,

there is no direct export option available but you can copy excel as image and then paste it into excel.

for that right click on chart -> copy to Clipboard -> Image

or go to chart property->Caption->enable copy image to clipboard option

Regards

Re: Export image from a table to excel

Tue, 23 Feb 2016 11:31:00 GMT

Hey guys,

Thanks for your help and suggestions...

I think I will have to use macros, because I dont think the client wont do many copy and pasting, they only want click in a button a get the result.

Re: Export image from a table to excel

avinashelite — Tue, 23 Feb 2016 11:58:02 GMT

you can also try with the Nprinting tool ...that might help you

Re: Export image from a table to excel

alex_millan — Tue, 23 Feb 2016 13:20:59 GMT

Hi Iuri,

If yo finally go for the macro option, remember that macro execution is only functional where you're accessing the QlikView application with the plug-in in Internet Explorer.

Regards

Re: Export image from a table to excel

fonmarcelo — Tue, 23 Feb 2016 13:25:14 GMT

Hello!

It's not possible. Because QlikView to Excel only send texts.

Re: Export image from a table to excel

Anonymous — Mon, 04 Sep 2017 12:27:29 GMT

are you sure? so is there any alternative?