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 the same Excel file. The only solution I could imagine, it is to put the XLS formatter (apply) node outside a loop, but I wonder whether it exists a KNIME loop allowing this and if eventually this is possible to be done.



1 Like