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.

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

2 Likes

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