My workflow writes an excel file, with a variable amount of sheets(Can be two sheets, but also seven, depending on the calculations).
As the amount of sheets is variable, I subsequently loop over the available sheets to apply an excel format. This works fine, as long as I have max 5 Sheets in the excel. Now I had the case that also a 6th sheet emerged and the XLS Formatter (apply) node throws this error:
ERROR XLS Formatter (apply) 0:288:13 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.
I also tried shuffling the sheet chronology for formatting, to exclude the possibility that one sheet was defect. I also excluded and included the sheets in different combinations, step loop analysis etc… The result was always the same: the last iteration failed in the “formatting loop”
Is there a limitation to the XLS Formatting nodes at this point in time, so it can only handle max 5 sheets?
The workflow looks like this: