pypi / xlsxwriter
xlsxwriter
What changed in xlsxwriter 1 to 3, from its official release notes, upgrade guides and advisories. Sources checked 2026-10-25.
3 breaking8 new APIs and options3 fixes and other
See which of these apply to your code, ranked, in your agent:
npx @unstale/cli initxlsxwriter 313 changes
Breaking changes 3
Priorities now follow the order in which rules were added when a cell range is repeated after a different range.
An unsupported source type now raises TypeError instead of ValueError.
An unsupported theme type now raises TypeError instead of ValueError.
New APIs and options 7
Adds a chartsheet method that automatically fits the sheet to the screen, including when the window is resized.
Adds a method to set the default workbook theme from a user-supplied .thmx, .xlsx, or theme1.xml file.
Adds a constructor option to change the default font and cell size to match the theme.
Adds a constructor option to change the default font and cell size to match the theme.
Adds a constructor option to change the default font and cell size to match the theme.
Adds the description option for worksheet Table alt text.
Adds the title option for worksheet Table alt text.
Fixes and other changes 3
Checks that the range is within worksheet limits, preventing corrupt files for large worksheets.
Prevents a spurious Invalid cell reference warning when a chart series uses a defined name with a sheet reference.
Fixes width and height detection for large GIF and top-down BMP images, and adds dimension validation.
xlsxwriter 11 changes
New APIs and options 1
Icon sets were added to conditional formatting, allowing developers to use them in conditional formats.