ValueError: Maximum 31 characters allowed in sheet title

[Davide Setti]

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

[CharlieC]

I think the limit is one of historical compatibility. Excel certainly won't let you set titles with longer names and regards files which have them as corrupt, as does the validator.

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.

[Davide Setti]

@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.

[CharlieC]

It's the same code whether you're reading an existing workbook or creating a new one.

[CharlieC]

Worksheet titles longer than 31 characters now issue only a warning not an exception. Excel is the biggest problem here. Resolves #694

→ <<cset cf11743fc291>>

[CharlieC]

Removing version: 2.4.x (automated comment)