NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
crates.io
crates.io, #2579 most downloaded on crates.io
An Excel/OpenDocument Spreadsheet reader and deserializer in pure Rust
Latest stable
0.38.0
Last release 20 days ago
02 Nov 2026
Ships fairly regularly
a new release about every 4 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
10 years old
84 releases · first in 2016
Drag across the ruler to compare, or tap a release to open it.
Added an XLSX API to read cell styles. A long requested feature.
Added an XLSX API to read cell styles. A long requested feature.
The new worksheet_style() method returns a StyleRange of Style values
holding the font, fill, borders, alignment, number format and protection of
each cell, with theme and indexed colors resolved, including tints.
For streaming, XlsxCellReader adds the next_cell_with_style_id() method,
which returns each cell value together with its style id in a single pass, and
styles() to resolve the id to a Style. Formats without style support
return an empty StyleRange. See also the xlsx_style_stream.rs example. PR
#653 and PR #682.
Added workbook_properties() methods to Xls and Ods in addition to the
xlsx and xlsb support in the previous release. The workbook document
properties can now be read from all the supported formats, including via
open_workbook_auto(). PR #756 and PR #757.
Added WorkbookProperties::custom_properties to read the custom, user
defined, document properties as a map of property name to text value.
PR #750.
Fixed XLSX reading of packages whose main workbook part isn't named
xl/workbook.xml. The part name is now read from _rels/.rels. Issue #752
and PR #753.
Fixed XLSX decoding of _xHHHH_ string escapes to handle all UTF-16 code
units, including surrogate pairs, instead of only _x00HH_. PR #751 and
PR #767.
Fixed XLSB date and time formats not being applied to whole-number cell
values stored as integer RK records. These were returned as Data::Int
instead of Data::DateTime. PR #758.
Fixed an XLSB panic on malformed BrtName records, which now return an
error. Issue #760 and PR #761.
Fixed a panic and an unbounded allocation in the CFB reader on malformed compound files, which affected XLS files and VBA projects. PR #762.
Fixed the XLS reader to ignore the case of the Workbook and Book stream
names, so that files with a WORKBOOK stream open as they do in LibreOffice.
Issue #618 and PR #755.
Fixed XLS decoding of BIFF5 strings in multibyte code pages such as Shift-JIS, GBK and Big5, which previously acquired NUL and replacement characters. PR #765.
Fixed an XLS panic on BIFF5 formulas with a PtgStr string literal, which
has no flags byte before BIFF8. PR #703.
Fixed ODS error cells, such as #DIV/0!, to return their displayed text
instead of an empty string. Issue #720 and PR #739.
Fixed ODS cell text to include tabs (text:tab) and soft line breaks
(text:line-break), which were previously dropped. PR #759.
Fixed ExcelDateTime::to_ymd_hms_milli() for times that round up to
midnight, which were returned as hour 24 of the same day instead of rolling
over to the next day. PR #763.
Full Changelog: https://github.com/tafia/calamine/compare/v0.37.0...v0.38.0
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Added an XLSX API to read cell styles. A long requested feature.
The new worksheet_style() method returns a StyleRange of Style values
holding the font, fill, borders, alignment, number format and protection of
each cell, with theme and indexed colors resolved, including tints.
For streaming, XlsxCellReader adds the next_cell_with_style_id() method,
which returns each cell value together with its style id in a single pass, and
styles() to resolve the id to a Style. Formats without style support
return an empty StyleRange. See also the xlsx_style_stream.rs example. PR
#653 and PR #682.
Added workbook_properties() methods to Xls and Ods in addition to the
xlsx and xlsb support in the previous release. The workbook document
properties can now be read from all the supported formats, including via
open_workbook_auto(). PR #756 and PR #757.
Added WorkbookProperties::custom_properties to read the custom, user
defined, document properties as a map of property name to text value.
PR #750.
Fixed XLSX reading of packages whose main workbook part isn't named
xl/workbook.xml. The part name is now read from _rels/.rels. Issue #752
and PR #753.
Fixed XLSX decoding of _xHHHH_ string escapes to handle all UTF-16 code
units, including surrogate pairs, instead of only _x00HH_. PR #751 and
PR #767.
Fixed XLSB date and time formats not being applied to whole-number cell
values stored as integer RK records. These were returned as Data::Int
instead of Data::DateTime. PR #758.
Fixed an XLSB panic on malformed BrtName records, which now return an
error. Issue #760 and PR #761.
Fixed a panic and an unbounded allocation in the CFB reader on malformed
compound files, which affected XLS files and VBA projects. PR #762.
Fixed the XLS reader to ignore the case of the Workbook and Book stream
names, so that files with a WORKBOOK stream open as they do in LibreOffice.
Issue #618 and PR #755.
Fixed XLS decoding of BIFF5 strings in multibyte code pages such as
Shift-JIS, GBK and Big5, which previously acquired NUL and replacement
characters. PR #765.
Fixed an XLS panic on BIFF5 formulas with a PtgStr string literal, which
has no flags byte before BIFF8. PR #703.
Fixed ODS error cells, such as #DIV/0!, to return their displayed text
instead of an empty string. Issue #720 and PR #739.
Fixed ODS cell text to include tabs (text:tab) and soft line breaks
(text:line-break), which were previously dropped. PR #759.
Fixed ExcelDateTime::to_ymd_hms_milli() for times that round up to
midnight, which were returned as hour 24 of the same day instead of rolling
over to the next day. PR #763.
Full Changelog: v0.37.0...v0.38.0
Updated dependencies for release 0.37.0:
Updated dependencies for release 0.37.0:
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 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.
examples/read_hyperlinks.rs by @musicinmybrain in https://github.com/tafia/calamine/pull/736Full Changelog: https://github.com/tafia/calamine/compare/v0.36.1...v0.37.0
Updated dependencies for release 0.37.0:
workbook_properties() methods to Xlsx, Xlsb and Sheets to readWorkbookProperties struct. Issue #677 and PR #685.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.
examples/read_hyperlinks.rs by @musicinmybrain in #736Full Changelog: v0.36.1...v0.37.0
Fixed a regression in 0.36.0 that broke Strict OOXML (ISO/IEC 29500) _rels/.rels links.
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.
Full Changelog: v0.36.0...v0.36.1
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.
Full Changelog: https://github.com/tafia/calamine/compare/v0.36.0...v0.36.1
For historical reasons the XLSX methods for accessing merged cells were duplicated. This change introduces a cleaner API, deprecates the older methods…
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.
Updated dependencies and the minimum supported Rust version (MSRV) for
release 0.36.0:
atoi_simd: 0.17 → 0.18. PR #672zip: 7.0 → 8.6. This raises the MSRV from 1.83 to 1.88. PR #672quick-xml: 0.39 → 0.41, to address advisories RUSTSEC-2026-0194 andPerformance improvements:
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 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.
* fill operator in custom number format detection by @greymoth-jp in #667Full Changelog: v0.35.0...v0.36.0
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.
Updated dependencies and the minimum supported Rust version (MSRV) for release 0.36.0:
atoi_simd: 0.17 → 0.18. PR #672zip: 7.0 → 8.6. This raises the MSRV from 1.83 to 1.88. PR #672quick-xml: 0.39 → 0.41, to address advisories RUSTSEC-2026-0194 and
RUSTSEC-2026-0195. Issue #674.Performance improvements:
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 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.
* fill operator in custom number format detection by @greymoth-jp in https://github.com/tafia/calamine/pull/667Full Changelog: https://github.com/tafia/calamine/compare/v0.35.0...v0.36.0
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 .
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.
Added deserialization examples. PR #649.
Performance improvements:
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.
<v> cell value parsing by @alexander-beedie in #622Full Changelog: v0.34.0...v0.35.0
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.
Added deserialization examples. PR #649.
Performance improvements:
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.
<v> cell value parsing by @alexander-beedie in https://github.com/tafia/calamine/pull/622Full Changelog: https://github.com/tafia/calamine/compare/v0.34.0...v0.35.0
Updated benchmarking to uses the criterion.rs crate. This removed the requirement for using +nightly for cargo bench . PR #620 .
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:
quick-xml: 0.38 -> 0.39. PR #617Refactored CFB to resolve special case in the caller of fn get_chain.
PR #615.
Performance improvements:
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.
fast_float2 used at all float-parsing call sites by @alexander-beedie in #608xls sector chain reads by @alexander-beedie in #609Full Changelog: v0.33.0...v0.34.0
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:
quick-xml: 0.38 -> 0.39. PR #617Refactored CFB to resolve special case in the caller of fn get_chain.
PR #615.
Performance improvements:
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.
fast_float2 used at all float-parsing call sites by @alexander-beedie in https://github.com/tafia/calamine/pull/608xls sector chain reads by @alexander-beedie in https://github.com/tafia/calamine/pull/609Full Changelog: https://github.com/tafia/calamine/compare/v0.33.0...v0.34.0
Added support for reading data from Pivot Tables, which involves reading data from the internal Pivot Cache. PR #559 .
Update dependencies for release 0.33.0:
zip: 4.2.0 -> 7.0.atoi_simd: 0.16 -> 0.17Fixed 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:
MAX_COLUMNS (16,384).MAX_ROWS (1,048,576).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.
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.
Full Changelog: v0.32.0...v0.33.0
Fixed out-of-memory vulnerabilities in XLS file parsing by bounding allocations.
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 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.
Full Changelog: v0.31.0...v0.32.0
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 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.
Full Changelog: https://github.com/tafia/calamine/compare/v0.31.0...v0.32.0
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
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.
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 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.
Full Changelog: https://github.com/tafia/calamine/compare/v0.30.1...v0.31.0
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.
ExcelDateTime to convert the inner serialFixed 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.
Full Changelog: v0.30.1...v0.31.0
Added Debug and Clone to Table for easier debugging. [PR #547].
Added Debug and Clone to Table for easier debugging. PR #547.
Fixed issue Issue #548 for xls files where the SST record had an incorrect
number of unique strings.
#[derive(Debug, Clone)] on Table by @lukapeschke in https://github.com/tafia/calamine/pull/547Full Changelog: https://github.com/tafia/calamine/compare/v0.30.0...v0.30.1
Debug and Clone to Table for easier debugging. PR #547.SST record had an incorrect#[derive(Debug, Clone)] on Table by @lukapeschke in #547Full Changelog: v0.30.0...v0.30.1
Unpinned the zip.rs dependency from v4.2.0 to allow cargo to choose the correct version for the user's rustc version.
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.
Full Changelog: v0.29.0...v0.30.0
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.
Full Changelog: https://github.com/tafia/calamine/compare/v0.29.0...v0.30.0
Add additional documentation and examples for the Range , Cell , XlsxError and Table structs, and Xlsx Table and Merge methods. Issue #459
Range, Cell, XlsxErrorTable structs, and Xlsx Table and Merge methods. Issue #459Pin zip.rs to v4.2.0.
The current latest release of zip.rs, v4.3.0, requires a MSRV of v1.85.0.
This release pins zip.rs to v4.2.0 to allow users to maintain a MSRV of
v1.73.0 for at least one more release. It is likely that calamine v0.30.0 or
later will move back to the latest zip.rs v4.x and require rustc v1.85.0.
Xlsx::from_sparse() and also ensured that theRange of cells would be in row-column order. PR #524.Full Changelog: v0.28.0...v0.29.0
Range, Cell, XlsxError
and Table structs, and Xlsx Table and Merge methods. Issue #459Pin zip.rs to v4.2.0.
The current latest release of zip.rs, v4.3.0, requires a MSRV of v1.85.0.
This release pins zip.rs to v4.2.0 to allow users to maintain a MSRV of
v1.73.0 for at least one more release. It is likely that calamine v0.30.0 or
later will move back to the latest zip.rs v4.x and require rustc v1.85.0.
Xlsx::from_sparse() and also ensured that the
associated Range of cells would be in row-column order. PR #524.Full Changelog: https://github.com/tafia/calamine/compare/v0.28.0...v0.29.0
bump v0.27.0 by @tafia in https://github.com/tafia/calamine/pull/499
Full Changelog: https://github.com/tafia/calamine/compare/v0.27.0...v0.28.0
(xls): add one more Error variant related to formatting.
Error variant related to formatting.Full Changelog: https://github.com/tafia/calamine/compare/v0.26.1...v0.27.0
Sparse cells expect 0 index rows, even when using header_row.
header_row.Full Changelog: https://github.com/tafia/calamine/compare/v0.26.0...v0.26.1
Ability to merge cells from xls and xlsx.
header_row config.docs.rs build.DataRef type by @wdoppenberg in https://github.com/tafia/calamine/pull/464Full Changelog: https://github.com/tafia/calamine/compare/v0.25.0...v0.26.0
Add is_error and get_error methods to the DataType trait.
is_error and get_error methods to the DataType trait.Range::headers method.Dimensions methods.OnceLock instead of once_cell crate (MSRV: 1.71).with_deserialize_headers method for `RangeDeserializerBui… by @lucatrv in https://github.com/tafia/calamine/pull/408Range::headers method by @lucatrv in https://github.com/tafia/calamine/pull/413Xlsx::worksheet_range_ref by @lucatrv in https://github.com/tafia/calamine/pull/414zip with zip_next by @Pr0methean in https://github.com/tafia/calamine/pull/423Full Changelog: https://github.com/tafia/calamine/compare/v0.24.0...v0.25.0
Introduce a DataType trait implemented by both Data and DataRef.
DataType trait implemented by both Data and DataRef.Data and DataType now return Some(0{.0}) and Some(1{.0}) rather than
None when .as_i64 or .as_f64 is used on a Bool value.is_x methods for date and time variants.DataType enum to Data and DataTypeRef to DataRef._rels files.DataTypeRef public and introduce a DataTypeTrait trait by @lukapeschke in https://github.com/tafia/calamine/pull/390de_opt_f64 example by @lucatrv in https://github.com/tafia/calamine/pull/398Full Changelog: https://github.com/tafia/calamine/compare/v0.23.1...v0.24.0
worksheet_formula not returning all formula.
worksheet_formula not returning all formula.Full Changelog: https://github.com/tafia/calamine/compare/v0.23.0...v0.23.1
New DataTypeRef available from worksheet_range_ref to reduce memory usage.
DataTypeRef available from worksheet_range_ref to reduce memory usage.chunks instead of chunks_exact by @jqnatividad in https://github.com/tafia/calamine/pull/379Full Changelog: https://github.com/tafia/calamine/compare/v0.22.1...v0.23.0
Spelling of formula error type.
Range::get.with_capacity() by @RoloEdits in https://github.com/tafia/calamine/pull/364Full Changelog: https://github.com/tafia/calamine/compare/v0.22.0...v0.22.1
Add support of sheet type and visibility.
de_opt_f64 example.de_opt_f64 example by @lucatrv in https://github.com/tafia/calamine/pull/338Full Changelog: https://github.com/tafia/calamine/compare/v0.21.2...v0.22.0
Formula with string not displaying properly.
Full Changelog: https://github.com/tafia/calamine/compare/v0.21.1...v0.21.2
Bump MSRV to 1.60.0 due to log dependencies.
Full Changelog: https://github.com/tafia/calamine/compare/v0.21.0...v0.21.1
Support PROJECTCOMPATVERSION in vba.
r attribute.PROJECTCOMPATVERSION in vba.Full Changelog: https://github.com/tafia/calamine/compare/v0.20.0...v0.21.0
(all) parse format/style information to infer cell as datetime.
Full Changelog: https://github.com/tafia/calamine/compare/v0.19.1...v0.20.0
bump dependencies, including quicl-xml 0.25 by @tafia in https://github.com/tafia/calamine/pull/274
Full Changelog: https://github.com/tafia/calamine/compare/v0.19.0...v0.19.1
Always return sheet names in lexicographic order (BTreeMap).
BTreeMap).open_workbook() for xls may panic or failed. by @visig9 in https://github.com/tafia/calamine/pull/236[badges] section from Cargo.toml by @striezel in https://github.com/tafia/calamine/pull/244Full Changelog: https://github.com/tafia/calamine/compare/v0.17.0...v0.19.0
Improve conversions from raw data to primitives.
Use chunks_exact instead of chunks where possible.
chunks_exact instead of chunks where possible.u32::MAX.to_u32, read_slice safe and sound.Full Changelog: https://github.com/tafia/calamine/compare/v0.16.2...v0.17.0
Add deserialize_with example in README.
deserialize_with example in README.Full Changelog: https://github.com/tafia/calamine/compare/v0.16.1...v0.16.2
Make Metadata.sheets (and Reader.sheet_names) always return names in workbook order.
Metadata.sheets (and Reader.sheet_names) always return names in
workbook order.Full Changelog: https://github.com/tafia/calamine/compare/v0.16.0...v0.16.1
Deprecate failure and impl std::Error for all errors.
std::error::Error for all errors.dates feature to enrich DataType with date conversions functions.dates feature by @tafia in https://github.com/tafia/calamine/pull/156Full Changelog: https://github.com/tafia/calamine/compare/v0.15.6...v0.16.0
## Added - Update dependencies. Full Changelog: https://github.com/tafia/calamine/compare/v0.15.5...v0.15.6
Full Changelog: https://github.com/tafia/calamine/compare/v0.15.5...v0.15.6
fix u32 overflow in xls::parse_dimensions() when (rl>0 && cl==0) by @shamiao in https://github.com/tafia/calamine/pull/151
u32 overflow in xls::parse_dimensions() when (rl>0 && cl==0) by @shamiao in https://github.com/tafia/calamine/pull/151Full Changelog: https://github.com/tafia/calamine/compare/v0.15.4...v0.15.5
Make it more user friendly by @tafia in https://github.com/tafia/calamine/pull/144
Full Changelog: https://github.com/tafia/calamine/compare/v0.15.3...v0.15.4
Add several new convenient fn to DataType.
DataType.Range::range fn to get sub-ranges.Range::cells iterator.DoubleEndedIterator when possible.Range::get fn (similar to slice's).size_hint impl in iterators.ExactSizeIterator.Full Changelog: https://github.com/tafia/calamine/compare/v0.15.2...v0.15.3
Consider empty cell as empty str if deserializing to str or String.
Full Changelog: https://github.com/tafia/calamine/compare/v0.15.1...v0.15.2
Xls - allow sectors ending after eof (truncate them!).
Full Changelog: https://github.com/tafia/calamine/compare/v0.15.0...v0.15.1
Codepage/encoding_rs for codepage mapping.
encoding_rs for codepage mapping.Full Changelog: https://github.com/tafia/calamine/compare/v0.14.10...v0.15.0
Serde map do not stop at first empty value.
Full Changelog: https://github.com/tafia/calamine/compare/v0.14.9...v0.14.10
Do not return map keys for empty cells. Fixes not working #[serde(default)].
#[serde(default)].Full Changelog: https://github.com/tafia/calamine/compare/v0.14.8...v0.14.9
Add a RangeDeserializerBuilder::with_headers fn to improve serde deserializer.
RangeDeserializerBuilder::with_headers fn to improve serde deserializer.Full Changelog: https://github.com/tafia/calamine/compare/v0.14.7...v0.14.8
Ods, support *text:s* and *text:p*.
Full Changelog: https://github.com/tafia/calamine/compare/v0.14.6...v0.14.7
Richtext for ODS by @tafia in https://github.com/tafia/calamine/pull/131
MulRk for xls files.Full Changelog: https://github.com/tafia/calamine/compare/v0.14.4...v0.14.6
Properly parse richtext ods files.
Ods: display sheet names in order.
Full Changelog: https://github.com/tafia/calamine/compare/v0.14.3...v0.14.4
Handle 'covered cells' which are behind merge-cells in ODS.
Full Changelog: https://github.com/tafia/calamine/compare/v0.14.2...v0.14.3
Boolean detection and missing repeated cells in ODS.
Full Changelog: https://github.com/tafia/calamine/compare/v0.14.1...v0.14.2
Possibility of index out of bound in get_value and eventually in Index<(usize, usize)>.
get_value and eventually in Index<(usize, usize)>.Full Changelog: https://github.com/tafia/calamine/compare/v0.14...v0.14.1
Have Range start/end return None if the range is actually empty.
start/end return None if the range is actually empty.Range::get_value return an Option if the index is out of range.Full Changelog: https://github.com/tafia/calamine/compare/v0.13.1...v0.14
Make Range::from_sparse public.
Range::from_sparse public.Migrate from error-chain to failure.
encoding_rs and zip).### Added - Update dependencies.
### Added - Add serde deserialization.
Update dependencies, in particular quick-xml 0.9.1.
Add a bound check when decoding cfb.
### Changed - Bump dependencies. - Ignore .bk files.
### Changed - Bump dependencies.
Update to quick-xml 0.7.3 and encoding_rs 0.6.6.
encoding_rs 0.6.6.One column per quarter.