Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting Images to Excel

Hello,

I am a new QlikView designer and have come across an issue that I can't find a resolution for and I'm hoping someone may be able to help. 

I created a dashboard that displays images of our SKU's via a table box.  The data source for the image is the file path name to the image on our server, which is listed on a MS Excel CSV file.  I have no problem getting the image to display on the dashboard, however when we export the table box into Excel only the file path is displayed.  Does anyone know if it is possible to have the image exported into Excel instead of the file path?

I was given some direction to look into writing a VB or java script macro, but I thought this would be a good place to start.  Your help is greatly appreciated. 

-Robert

1 Reply
Not applicable
Author

The easiest macro would be something like this.  However, you would lose the functionality of being able to select SKUs and their associated images in Excel. I'm sure it would be possible to have your macro loop through each SKU and insert the image in Excel, but it would probably be cumbersome and I generally prefer to sta away from macros whenever possible.  Hope this gets you started.