v0.37.0 - 2026-10-18

Changed

• Updated dependencies for release 0.37.0:

  • zip: 8.6 to 9.0, since the 8.x releases were yanked upstream. ZipError
    is part of the public error types, hence the minor version bump. PR #741.
  • quick-xml: 0.41 to 0.42. PR #711.

Added

• Added workbook_properties() methods to Xlsx, Xlsb and Sheets to read
  the workbook document properties, such as creator, title, and creation date,
  into a new WorkbookProperties struct. Issue #677 and PR #685.

Fixed

• Fixed an issue with XLS worksheets that contain nested substreams, such as an
  embedded chart, leaking the chart cells into the worksheet. PR #701.

• Fixed an issue where the column letters beyond Z in formulas where
  reconstructed incorrectly. PR #699.

• Fixed the XLSX 1904 date epoch flag being reset by an <x15:workbookPr>
  extension element. Issue #706.

• Fixed an issue to allow XLSX formula string results to decode Excel _xHHHH_
  escapes, in the same way as shared and inline strings. PR #727.

• Fixed an issue to allow XLSX hyperlink attributes to decode XML entities, so
  that & in a URL is no longer returned as &. PR #728.

• Fixed an XLS panic on a PtgExp formula token with a truncated operand.
  PR #707.

• Fixed XLS parsing of PtgStr formula tokens with UTF-16 string operands.
  PR #730.

• Fixed XLS parsing to accept DIMENSIONS records with 2 extra trailing bytes.
  PR #735.

• Fixed the CFB reader to check the header sector counts before allocating, to
  avoid huge allocations on corrupt files. PR #729.

• Fixed the East Asian built-in number formats (ids 27-36 and 50-58) to be
  recognized as dates and times instead of numbers. PR #734.

• Fixed a panic in ExcelDateTime::to_ymd_hms_milli() for very large serial
  dates. Values are now limited to 9999-12-31. Issue #722.

• Fixed XLSX boolean cells to only accept 0, 1, false and true. Any
  other value is now an error instead of being read as true. Issue #724.

What's Changed

• fix(xls): skip nested substreams so embedded charts do not leak cells by @Nitjsefnie in #701
• fix(xls/xlsb): correct column letters in reconstructed formulas (columns >= AA) by @binggao1230 in #699
• xls: fix panic on a PtgExp token with a truncated operand by @Butch78 in #707
• xlsx: don't let x15:workbookPr reset the date1904 flag by @youdie006 in #708
• update quick-xml to 0.42.0 by @WindSoilder in #711
• chore(deps): upgrade zip to 9.0 by @chardoncs in #741
• feat(xlsx/xlsb): read workbook document properties by @Alex-ley-scrub in #685
• xlsx: unescape Excel xml escapes in formula string results by @keithadler in #727
• xlsx: decode XML entities in hyperlink attributes by @youdie006 in #728
• xls: fix PtgStr parsing for UTF-16 string operands by @shinichi1729 in #730
• fix(xls): accept DIMENSIONS records with 2 extra trailing bytes by @DylanMerigaud in #735
• Fix CRLF line termination in examples/read_hyperlinks.rs by @musicinmybrain in #736
• Recognize East Asian built-in date and time formats by @Floating-Y in #734
• datetime: limit serial values in to_ymd_hms_milli() by @jmcnamara in #747
• xlsx: check/reject invalid boolean cell values by @jmcnamara in #749

New Contributors

• @Nitjsefnie made their first contribution in #701
• @binggao1230 made their first contribution in #699
• @Butch78 made their first contribution in #707
• @youdie006 made their first contribution in #708
• @chardoncs made their first contribution in #741
• @Alex-ley-scrub made their first contribution in #685
• @keithadler made their first contribution in #727
• @shinichi1729 made their first contribution in #730
• @DylanMerigaud made their first contribution in #735
• @musicinmybrain made their first contribution in #736
• @Floating-Y made their first contribution in #734

Full Changelog: v0.36.1...v0.37.0