Need to extract image from excel sheet

[SABAREESHS37]

Good Morning Everyone,

I need to extract set of images from from excel sheet and merge the image with particular details of previous document
i have tried image reader and dont want to download and upload it but the question is i have n number of excel document and cant add the images so please guide me

[SABAREESHS37]

Scavenge Space inspection report.xlsx (1.6 MB)

[ScottF]

Hi @SABAREESHS37 -

It’s not 100% clear to me what you’re trying to do, I gather that generally you want to bring images embedded in an Excel sheet into KNIME so you can work with them further. This thread has a few possible ways to go about that:

export pictures from Excel xls or xlsx

Hi all, I have a excel file with pictures of curves in it. Now I like to export these curves in Knime from the Excel file to a directory. I could not find a way on the internet. With a VB script this is possible, but like to do this in Knime, because I also use Knime for the rest of the data handling. This is an Excelfile with the pictures. It is not about the colored dots in column D,E or F, but the graphs in column N. Knime DRC example Export AB.xlsx (80.6 KB) Thanks, Ron

If you can find a solution that works for a single Excel file, then you can implement looping for an arbitrary number of Excel files. So I’d start with that thread (in particular, the link to Gabriel’s proposed solution) and see if that gets you any closer.

If you continue to run into trouble please post your workflow in progress so that maybe someone can assist.