Paste screenshot in Excel file

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.

4 Likes