I have followed this thread, and I have seen that as of May 2019, this feature was not implemented in Knime. However, I would like to know if it is already available today, and if not, when it is expected to be available.
Thanks for using our extension! We have good news for you, the feature you are requesting is already included in the latest version.
In our documentation, you find it under XLS Sheet Selector Node.
Can I apply different formats to Excel sheets that are not generated in paralel but during a loop?
I have noticed that the node XLS Format Merged just works if both XLS Formatted are active. Is there any other node that is able to merge the XLS Formatted when one of them is empty.
Thank you very much and sorry for these difficult requirements.
Dear @CarolinaPR,
I’m not sure whether I fully understand your requirement. This is possible though, but a bit tricky. Please have a detailed look at this example workflow and let me know whether this is what you need. It iteratively adds multiple sheets’ formatting to the green port within a loop: