Hello, is there a way wherein a screenshot or image saved in a specific folder can be pasted in excel file via KNIME? Appreciate your inputs. Thanks! [sample screenshot paste in excel]

Write images to Excel.knwf (435.6 KB) The trick is to keep the image properties consistent throughout the process. Right click on the original image file to see the pixel width and height, use those pixel settings in the rendering node in KNIME, export it to the template file, go to the image cell and widen the column width and row height to allow for adequate space, right click on the image file and go to “size and properties”, then click on the “reset” button to go to the original size and aspect ratios, then resize the cell to match the image size, then delete image / save the template file. Then re-run the workflow. This way the cell in the template file will hold the correct size and avoid the blurry look caused by re-rendering in excel.

You can write an Image into an excel file using Excel Writer node. Here is a prototype: ImageToExcel.knwf (2.3 MB) Overview: [image] You can load an Image using Image Reader - then you render it to e.g. PNG and then can write it to Excel: [image] You’ll probably have to play around with some other topics settings to get it right, but hope this gets you started. You will have to manually find the image in the prototype - I have included it in the data folder of the workflow, but the image reader does not seem to support reading from that folder by default (as e.g. the excel reader does)

@trafalgarlaw you can use OpenPyxl bundled in KNIME to add images to excel [image] image to excel sheet KNIME Extensions @Barba you can export an images as a PNG file and then place it into an Excel file with the help of OpenPyxl and the bundled Python in KNIME : [image] combine image in different columns KNIME Analytics Platform @Aprins I have built a workflow to show how this could be done: save the image as PNG file export the data to an Excel sheet determine the number of Rows and add 2 (to give the image a little bit of space) use OpenPyxl to place the image under the table on the sheet starting in column A The image will be as large as the PNG file, starting in column A. [image] Maybe you can adapt this example: [image] [image] Excel - place PNG image on Sheet with OpenPyxl – mlauber71 Excel - place PNG image on Sheet with OpenPyxl - KNIME Forum (77693)

You can also do this with the Excel Write to Template node if you want to maintain formatting of an excel file. I find it to be the easiest and most flexible way to integrate or output to excel. I pretty much use it exclusively over the standard excel writer and formatting nodes.

But I want the screenshot to be pasted to an excel, not sure how it works in write to excel template?

Thank you @mlauber71 will check this!

It has been a while, but I believe that you need to read in the image file, then use PNG to Image Plus, then render and adjust image if necessary, then Image Plus to PNG again before writing to excel. I will try to put together an example workflow when I get an opening.

Write images to Excel.knwf (528.1 KB) Here are examples of how to write image files to excel using the Write to Excel Template node. I included a component that you can use to quickly access the workflow data folder or launch the excel files. Just execute it and open the interactive view, then you trigger a one time open by changing the dropdown to yes and hit refresh to open a file or folder selected to right. Works the same if you use Write to Excel. The template approach just simplifies formatting and opens additional excel side programming capabilities.

Hello @iCFO thank you for sharing it, but can I ask for a favor a screenshot of your configuration for write to excel template? I am not able to open it because of version diff. Appreciate it. Thank you!

Top node 1st tab [iCFO 8-13-2024 11.04.17 AM] Second tab settings for both nodes [iCFO 8-13-2024 11.04.47 AM] Bottom node 1st tab [iCFO 8-13-2024 11.05.05 AM] I will add that the “Remove all Data Before Writing” setting does not appear to remove png images from the template file write area as it does with other data types. Instead it appears to write the new image over the old ones. I recommend creating a template file that has all of the data cleared, then selecting “Create New File” at the bottom of tab 1. That way it always creates a new file with the data written into it avoiding the issue. @AnotherFraudUser - Just tagging you to give a heads up that images don’t appear to be cleared with the remove all data option. However, I could see how that could be a benefit in some instances and a hindrance in others…

Paste screenshot in Excel file

KNIME Analytics Platform

mlauber71 August 5, 2024, 12:24pm 3

@trafalgarlaw you can use OpenPyxl bundled in KNIME to add images to excel

Write to Excel so the pictures are placed in cell and alt text is included

Save table with PIL images in Table using Python scripts