search

randym / axlsx

xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
MIT License
2.62k stars 697 forks source link

Set column width to the maximum allowed value #653

Open sponomarev opened 4 years ago

sponomarev commented 4 years ago

Maximum column width limit in MS Excel is 255 characters https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

If this value is exceeded, MS Excel gets stuck and doesn't allow column resizing.

noniq commented 4 years ago

That looks great! This repo isn‘t actively maintained at the moment though, but I’d love to merge this into the community continued version at https://github.com/caxlsx/caxlsx – could you open a PR over there?

sponomarev commented 4 years ago

@noniq Done! caxlsx port https://github.com/caxlsx/caxlsx/pull/53