Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export image from a table to excel

Hello,

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

NameSurnameSalesPhoto
JonJon700
ManuelPopayan700
AnaLalas800
MartaBaiao900

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

9 Replies
luciancotea
Specialist
Specialist

No, Excel doesn't have that feature.

Chanty4u
MVP
MVP

ramasaisaksoft

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.

PrashantSangle

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

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

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.

avinashelite

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

alex_millan
Creator III
Creator III

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

fonmarcelo
Contributor III
Contributor III

Hello!

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

Anonymous
Not applicable
Author

are you sure? so is there any alternative?