Read MS Excel files and extract pictures!

[kristo5747]

Hello!

I was given a bunch of MS Excel files (Office 2007) that contain pictures (JPEG format).

My assignment is to extract the pictures and dump them on a web server for easy access.

I found a package on sourceforge called `phpexcelreader` but it is no longer maintained.

Is it at all feasible? Can someone share some insight?

Thanks.

Al.

[Demaestro]

Are the images actually embedded in the Excel file or does the excel file reference the physical location of an image in a db, online or as a file on disk?

[kristo5747]

Embedded in the Excel file, which is the challenge...I think.

[Demaestro]

Yikes,,, that sounds ugly.

You can write a macro that exports them to a folder, but you would have to be able to execute that server side, or execute it on a machine that can do this... then upload the resulting directory to the server.

[kristo5747]

'Ugly' is putting it mildly.

Thanks to Google, I found a VBA macro that can do the trick.

The integration is another story but so far, VBA seems to work.

[Demaestro]

Good luck, if you have more questions post back and I will try to help.