I want to format an Excel file I previously created via the “Excel Writer” node. My workflow looks like this:
- Read existing Excel-file
- Transform the data
- Write into new file
- Format the new file
But when I try to load the file via “XLS Formatter (apply)” node, I always receive the “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.” error. I don’t apply formatting styles anytime before as I only perform transformations based on the content of the cells.
What can I do to overcome this issue? Is there a way to “delete” every formatting that may have been applied previously?