Hi guys, 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: [image] Cheers, Stiefel

Hello @Residentstiefel , seems like same issue as here: [image] Formatting Loop Fails On Fifth Iteration Community Extensions 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 bey… Br, Ivan

Limitiations of Excel Formatter (number of sheets restricted)?

Community Extensions

ipazin April 19, 2021, 10:41am 4

Hello @Residentstiefel,

seems like same issue as here:

Br,
Ivan

3 Likes