XLS formatting node is filling after 5 th iteration

[Residentstiefel]

Hi @johnnybasha ,

This issue was also discussed (and solved) here:

Limitiations of Excel Formatter (number of sheets restricted)?

Hi @Residentstiefel I have workflows that work using the Continental nodes with more than 6 sheets. I believe the problem is not the number of sheets, but the fact that your loop attemps to format an excel file which already contains a formating style, as indicated by the Execution Failed message displayed in your snapshot. Adding formatting to an already formatted excel file is so far not possible with the Continental nodes. I have never tried to dynamically add formatting within a loop for th…

Formatting Loop Fails On Fifth Iteration

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…

Cheers,
Stiefel