Hi,
Is there any way to read an image from a excel sheet or expose the hidden attribute/row that contains it?
Thanks
Question
read image in Excel sheet
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@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.
+21- Safer
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.
+12- Safer
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!
