Skip to main content
Question

read image in Excel sheet

  • November 14, 2019
  • 4 replies
  • 95 views

Forum|alt.badge.img

Hi,

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

Thanks

4 replies

Forum|alt.badge.img+2
  • November 15, 2019

@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.


fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • July 25, 2020

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


fmelizard wrote:

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.


saraatsafe
Safer
Forum|alt.badge.img+8
  • Safer
  • January 19, 2023
alan.philpott wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings