Hi all!
My workflow loops through XLSX files collecting certain data into a new table. Each table is appended as a new sheet to an XLS file. A unique styling table is made for each table in this process. The last step of the loop is applying the styling via the XLS Formatter node.
On the fifth loop through, the workflow returns the error:
ERROR XLS Formatter (apply) 0:38 Execute failed: The input file already contains formatting styles. This is currently unsupported in our extension beyond a degree that KNIME’s XLS Writer and Sheet Appender nodes would utilize.
The 5th table has been appended to the XLS file but has no visible formatting. The workflow completes successfully when only 4 XLSX files are looped through.
My troubleshooting and adjusting of flow variables haven’t fixed the issue yet. If anyone has ideas on how to fix this, or could link to a similar post, it’d be appreciated!
Here is a link to my workflow:
Attached is a screenshot of the workflow.