ValueError: Maximum 31 characters allowed in sheet title
Hi, I don't understand the limit of 31 chars as sheet title. I have a web app where people can load xmlx files to import data and I can't read some of them because of this limit. Where's the problem with long titles? Should I send a pull request to make it configurable?
Thanks
Comments (5)
-
-
@charlie clark i understand that it's useful to have such a limit when you create a file, but not when you read. BTW LibreOffice let you create such files, but as you say MS Office (2010) doesn't.
-
It's the same code whether you're reading an existing workbook or creating a new one.
-
- changed status to resolved
Worksheet titles longer than 31 characters now issue only a warning not an exception. Excel is the biggest problem here. Resolves
#694→ <<cset cf11743fc291>>
-
- removed version
Removing version: 2.4.x (automated comment)
- Log in to comment
Configurability of this is not something I keen on but I'd accept a change to a warning.
This should also be taken up with the OOXML working group.