I am using the XLS Sheet Appender node to add an image (PNG) to an existing XLSX file. In doing so, I run into two problems:
First, the image looks like garbage due to its display format (please see the attached screenshot). Is it possible to save the image into the XLSX file and have it displayed with 100% x- and y-dimensions?
Second, when re-executing the node, it fails with the following error message:
ERROR XLS Sheet Appender Execute failed: org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the name '/xl/media/image1.png' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12]
The only solution is to manually delete the sheet containing the image before re-executing the node. You will agree that this goes against the idea of KNIME.