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
@jaysavla welcome to the KNIME forum. The limit is 31 characters for Excel sheet names.
Hello @jaysavla,
you are right. There is already a ticket to handle it and I have given it +1 for you. (Internal reference: AP-15098). See this discussion as well :
As for workaround first thing that comes to my mind is vba. If you have fixed templates then rename by sheet index or create rules for mapping names from one written with KNIME to ones you need.
Welcome to KNIME Community!
Br,
Ivan
Thanks a Lot Ivan. Appreciate your help on this one!
Thanks for your help @mlauber71
Hello @jaysavla,
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.
Check release highlights here:
Br,
Ivan
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.