tafia/calamine
 Watch   
 Star   
 Fork   
简介统计版本
11 days ago
calamine
tafia

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 &amp;. 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

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.36.1...v0.37.0

2026-07-27 18:06:04
calamine
tafia

v0.36.1 - 2026-07-27

Fixed

  • Fixed a regression in 0.36.0 that broke Strict OOXML (ISO/IEC 29500) _rels/.rels links.

  • Fixed XLS string handling to preserve empty strings instead of discarding them. PR #679.

  • Fixed XLSB workbook parsing to consume the body of unhandled workbook-global records. A leftover body was misread as the next record id, which either silently dropped the worksheet or panicked from an empty buffer. PR #675.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.36.0...v0.36.1

2026-07-07 06:36:54
calamine
tafia

v0.36.0 - 2026-07-06

Added

  • Added an XLSX streaming API for cell and formula records, including shared formula metadata. There are two new APIs: XlsxCellReader::next_cell_with_formula() and XlsxCellReader::next_cell_with_formula_metadata(). Previously it required 2 separate reads to get similar information. PR #654.

  • Added a per-sheet, lazy XLSX API to read worksheet hyperlinks: Xlsx::hyperlinks_by_sheet_name() and Xlsx::hyperlinks_by_sheet_id(). Each hyperlink reports its anchor range (Dimensions), external target (URL/file/mailto), optional internal location, displayed text, and optional tooltip. PR #659.

  • Extended the picture feature to also extract cell position information and the raw image data, and to handle newer Excel 365 style embedded images. PR #652.

  • Added support for reading XLSX rich string (rstring) records. Issue #655.

Changed

  • Updated dependencies and the minimum supported Rust version (MSRV) for release 0.36.0:

  • Performance improvements:

    • Custom zero-overhead attribute extraction and optimized local_name matching. PR #621
    • Optimized buffer use for XLSB cell reads. PR #662

  • Refactored and unified the merged-cell handling APIs. For historical reasons the XLSX methods for accessing merged cells were duplicated. This change introduces a cleaner API, deprecates the older methods, and aligns the XLS merged-cell handling with the new XLSX APIs. Issue #536.

  • Made XLSX package path resolution more robust for non-standard package layouts. Issue #638.

  • Changed XLSX <t> text handling in shared strings and inline strings to trim leading and trailing ASCII whitespace (space, tab, CR, LF) unless the element carries xml:space="preserve". See PR #671 and PR #673.

Fixed

  • Fixed XLSX shared-formula cell-name replacement to be more precise for defined names. PR #664.

  • Fixed XLSX custom number-format detection to treat the * (fill/repeat) operator as escaping the character that follows it. PR #667.

  • Improved the XLS error message when a file is too small to be a valid workbook. PR #670.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.35.0...v0.36.0

2026-05-11 01:56:23
calamine
tafia

v0.35.0 - 2026-5-10

Added

  • Added has_1904_epoch() method to Xls/Xlsx/Xlsb structs to allow the user to determine which date epoch is in use by Excel. PR #630.

  • Made RowDeserializer public to allow a custom DeserializeSeed. PR #635.

Changed

  • Added deserialization examples. PR #649.

  • Performance improvements:

    • Optimized <v> cell value parsing. PR #622
    • Optimized cell reference parsing. PR #623

Fixed

  • Fixed issue with redundant <v> value in inlineStr XLSX cells. Issue #633.

  • Fixed issue when processing XLSX files to ignore namespace prefix when reading relation ids. Previously accepted only r: and relationships: prefixes. Issue #634.

  • Fixed XLSX issue where rich text <r> elements were ignored after initial plain <t> elements. Issue #636.

  • Fixed XLS issue where date format was ignored for formula values. Issue #640.

  • Fixed XLSX shared formula expansion corrupting function names. The replace_cell_names() function treated LOG10 as a cell reference (column LOG, row 10). Issue #644.

  • Fixed XLSX inlineStr issue for elements that contain CDATA. Issue #648.

  • Fixed panic when parsing formulas in XLS BIFF5 workbooks.The parse_formula function decoded the non-3D PtgRef, PtgArea, PtgRefErr, and PtgAreaErr tokens assuming BIFF8 sizes. PR #643.

  • Fixed XLS panic with unsupported formula functions. Handle unsupported XLS function ids as formula parse errors instead of indexing past the function table. Issue #646.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.34.0...v0.35.0

2026-03-07 22:28:20
calamine
tafia

v0.34.0 - 2026-03-07

Changed

  • Updated benchmarking to uses the criterion.rs crate. This removed the requirement for using +nightly for cargo bench. PR #620.

  • Updated dependencies for release 0.34.0:

  • Refactored CFB to resolve special case in the caller of fn get_chain. PR #615.

  • Performance improvements:

    • Cell reader buffer reuse and optimised maps. PR #611
    • Optimised XLS sector chain reads. PR #609
    • Ensured fast_float2 is used at all float-parsing call sites. PR #608
    • Cached path and attr lookups, reused buffers, minimised allocations. PR #606

Fixed

  • Fixed capitalized workbook/book stream handling in XLS files. PR #618.

  • Fixed issue where BIFF5 Lbl and ExternSheet records were incorrectly parsed as BIFF8. PR #613.

  • Fixed VBA check_variable_record to handle optional records. PR #614.

  • Fixed premature error when BIFF version is not Biff8 in XLS files. PR #619.

  • Fixed issue where XLSX cells with an empty <v/> value returned a string with index 0 instead of an Empty value. Issue #607.

  • Fixed millisecond rounding issue where 1000 milliseconds weren't rounded up to the next second. Issue #602, PR #605.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.33.0...v0.34.0

2026-02-05 01:09:42
calamine
tafia

v0.33.0 - 2026-02-04

Added

  • Added support for reading data from Pivot Tables, which involves reading data from the internal Pivot Cache. PR #559.

Changed

  • Update dependencies for release 0.33.0:

    • zip: 4.2.0 -> 7.0.
    • atoi_simd: 0.16 -> 0.17

Fixed

  • Fixed potential memory exhaustion issue in ODS files that could be triggered via repeated empty rows/columns.

    The fix adds limits to prevent memory exhaustion from malicious ODS files that declare billions of repeated cells via table:number-rows-repeated and table:number-columns-repeated attributes.

    The change adds the following protection layers:

    • Add cap for columns per row at MAX_COLUMNS (16,384).
    • Add cap for total row repeats at MAX_ROWS (1,048,576).
    • Add cap for total cells at MAX_CELLS (100 million) in get_range().

    These limits match XLSX's existing row/column limits and prevent a 7KB malicious file from attempting to allocate memory for 17+ billion cells.

    When MAX_CELLS is exceeded, return OdsError::CellLimitExceeded instead of silently returning an empty range. This ensures callers are properly informed of truncation rather than receiving silent data loss.

    Issue #594, PR #596.

  • Fixed an issue where XLSX files with tables that had the internal insertRow attribute set returned a Dimensions object where the end row was less than the start row. This caused an assert/panic when trying to create a Range object to return the table range. Issue #589.

  • Fixed an issue with XLSX files where worksheet tables used the unusual, but valid, absolute reference system like "/xl/tables/table1.xml" instead of the common Excel generated relative system "../tables/table1.xml". Issue #587.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.32.0...v0.33.0

2025-11-21 03:31:55
calamine
tafia

v0.32.0 - 2025-11-20

Changed

  • Refactored VBA reading functions to be on-demand for better performance.

  • Simplified vba_project() function return type from Option<Result<T>> to Result<Option<T>> for more idiomatic error handling. This is a breaking change.

Fixed

  • Fixed out-of-memory vulnerabilities in XLS file parsing by bounding allocations.

  • Fixed and extended support for XLSX shared formulas with handling of ranges, absolute references, and column/row ranges in XLSX files.

  • Fixed XLSX issue with missing shared string sub-elements. Also improved error messages for shared string parsing issues.

  • Fixed acceptance of XLS XLUnicodeRichExtendedString records without reserved tags.

  • Fixed various edge cases in XLS handling that could lead to parsing errors.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.31.0...v0.32.0

2025-09-28 00:50:22
calamine
tafia

v0.31.0 - 2025-09-27

Changed

  • Upgraded quick-xml to v0.38. This was a significant change in quick-xml relative to v0.37 and required changes in calamine to entity handling. It also fixes EOL handling which may lead to regressions in calamine applications if they expected to see "\r\n" in strings instead of the correct (for XML and Excel) "\n".

    For most users these will be inconsequential changes but please take note before upgrading production code.

  • Renamed the "dates" feature flag to "chrono" since there is now some native date handling features without "chrono". The "chrono" flag is more specific and accurate. The "dates" flag is still supported as before for backward compatibility.

    This change also made some datatype methods related to date/times available in the "default" feature set. They were previously hidden unnecessarily behind the "dates/"chrono" flag.

Added

  • Added a conversion function to ExcelDateTime to convert the inner serial Excel datetime to standard year, month, date, hour, minute, second and millisecond components. Works for 1900 and 1904 epochs.

Fixed

  • Fixed issue where Excel xlsx shared formula failed if it contained Unicode characters. Issue #553.

  • Fixed issue where Excel XML escapes in strings weren't unescaped. For example "_x000D_" -> "\r". Issue #469.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.30.1...v0.31.0

2025-09-07 00:10:04
calamine
tafia

v0.30.1 - 2025-09-06

Added

  • Added Debug and Clone to Table for easier debugging. PR #547.

Fixed

  • Fixed issue Issue #548 for xls files where the SST record had an incorrect number of unique strings.

What's Changed

Full Changelog: https://github.com/tafia/calamine/compare/v0.30.0...v0.30.1

2025-08-07 16:26:02
calamine
tafia

v0.30.0 - 2025-08-07

Changed

  • Unpinned the zip.rs dependency from v4.2.0 to allow cargo to choose the correct version for the user's rustc version.

    The Rust MSRV was bumped to v1.75.0 (which it should have been for for zip.rs compatibility in previous releases).

    See the discussion at Issue #527.

What's Changed

New Contributors

Full Changelog: https://github.com/tafia/calamine/compare/v0.29.0...v0.30.0