Skip to main content

Hi,

Is there any way to read an image from a excel sheet or expose the hidden attribute/row that contains it?

Thanks

@hrinze At the moment FME cannot read the images form an Excel file. XLSX files are zipped XML files, so you might be able to unpack the XML and uncover the images that way.


Hi @hrinze FME can now read images from Excel in the latest 2021.0 betas. These beta builds aren't available yet but should be soon from https://www.safe.com/support/downloads/#beta


Hi @hrinze FME can now read images from Excel in the latest 2021.0 betas. These beta builds aren't available yet but should be soon from https://www.safe.com/support/downloads/#beta

I can't seem to find any documentation or further articles on this. Is there somewhere describing how to read images from Excel files? Showing up as <missing> in 2022.2 after reading.


I can't seem to find any documentation or further articles on this. Is there somewhere describing how to read images from Excel files? Showing up as <missing> in 2022.2 after reading.

Hi @alan.philpott, our Excel reader documentation has some details on reading images-- if you expand the Advanced tab you will find more info under the Read Embedded Images As section. If you set the reader parameters to interpret images as Geometry, you should then be able to run your reader and see the images in Graphics view. 

We've looked into the missing attribute values and that is expected behaviour since images don't natively come with attribute values. You can try using the RasterExtractor to map attributes if you need to. I hope this helps!


Reply