Can you add Images into Excel Sheets with Knime?

[tschmied]

Hey Everyone!

I am trying to create a standard reporting tool using Knime that will take some data and export an Excel workbook with formatting and required data. I am wanting to add images into the sheets as either a logo at the top, and important graphs that add detail to the report.

Is it possible to add images into excel sheets?

[izaychik63]

Yes, look here for details

Images in Excel

This topic came up at our Learnathon in Cambridge this week and I learned that there were some unanswered questions on the Forum about how to get molecule images into Excel. Getting an Excel spreadsheet with a column containing PNGs with molecule images is actually pretty straightforward using the “Renderer to Image” node which is part of KNIME’s SVG support. The attached workflow shows how to do this using the Marvin renderer for an SDF column (can also be used for SMILES columns) and the RDK…

[tschmied]

Is there another way that does not require SQL files? It is great to know that it is done but that seems a bit complicated as I am still learning KNIME and have not dealt with SQL yet.

[ipazin]

Hi there @tschmied,

welcome to KNIME Community!

Sure there is. Try Image To Table node to have your image inside table and then export. Possible you will need Renderer to Image node in between

Br,
Ivan