Images from Excel File? Or an alternative?

[#1]

Hello!

Question two for the day.

I have a file full of images and names of our good MPs here in the UK. Looks like this:

Now, I was wondering if you guys knew of a way I could use these photos in a Qlikview file. They do seem to be linked to the cells they are in, sort of. I obviously tried a basic load, as below, but it failed.

Any ideas?

[german_avanzato]

You can just upload a full/relative path of the image files, and then use it.

[crusader_]

Hi,

You need to export your pictures as single files and then import them into QV app.

Hope this helps.

Regards,

Andrei

[#4]

Sigh, that will take forever with 650 images! Do you think there is a way of building a macro to do it?

[german_avanzato]

What kind of file is? SQL DataBase? Excel? ....other?

[#6]

Yup, Excel

[qlikoqlik]

Hi

read about bundle load

thanks

padma

[qlikoqlik · Accepted solution]

Hi

see the below thread

http://community.qlik.com/docs/DOC-3859

thanks

padma

[#9]

Thank you!

[#10]

For anyone else struggling, this is very useful:

http://www.excelforum.com/excel-general/959594-how-do-extract-all-images-from-a-excel-spreadsheet-all-at-once-into-a-folder.html