Excel file with embedded images

Hi,

I have an excel file with a column that contains images embedded in the rows.  If I try to read this file with the xls reader node it fails to recognise the images.  Is it possible to read these in using the node or an alternative?

Thanks,

A

Hi Angus, 

I wouldn't mind looking for a workaround, do you by chance have an example file I can use as a starting point?

Regards,

Aaron

Hi Aaron,

Sure, please find attached an example file.

Angus

Hmm, no luck so far but if you can save from xls as html (or open in libreoffice) it decomes easy to store the structures.  Alternatively, if you can configure XLS to save the smiles, and not the rendered images, we can re-render those easily in KNIME. 

Cheers,

Aaron

Hi Aaron,

Many thanks for trying, I do have the html files which I tried to bring in to knime but didn't really know the workflow for reading html files.

Thanks again,

Angus 

Hi Aaron,

Thanks for trying.  I do have the html files but was unsure of the workflow to read them in to knime in a sensible format.

Angus