Currently it seems that there is a limitation to create an excel file containing sheet name having more than 25 characters. Is there a way to change this? We have templates which require standard sheet names which are currently more than 25 characters and due to this limitation we are unable to have this automated completely at the moment.
Appreciate if someone can suggest a work around here in which we can have the sheet name created with more than 25 characters
this was addressed with new KNIME version 4.3.0. Now with Excel Writer sheet name can have up to 31 character which is Excel limit. In case you specify longer name you’ll get warning and won’t be able to configure node.