- Fix issue with some empty cell elements being returned as
:expect_formula
, they are now returned as empty strings
- Fix handling of cell type/style when some cell elements were missing attributes
- Handle date and datetime values encoded as numeric cell types
- Handle files without shared strings or styles relationships.
- Upgrade ex_doc
- Fix issue with some empty cell elements being returned as
:expect_chars
, they are now returned as empty strings.
- Improve handling of UTF-8/16/32 encoding
- Add
exclude_hidden_sheets?
option - Return
#ERROR
value instead of crashing in case of cell conversion error
- Add support for shared formulas
- Add
cell_data_format
option to return data asCell
structs instead of values
- Improve ZIP file error handling
- Update Saxy XML parser
- Improve UTF-16 support
- Update Saxy XML parser
- Require Elixir 1.10 to fix publishing of documentation
- Improve compatibility with XLSX writers (Excel for Mac, …) which completely omit empty rows in worksheets
- Add
skip_row?
callback
- Add support for
decimal ~> 2.0
- Add
:supported_custom_format
option toXlsxReader.open/2
- Support ISO 8601 and US date/time custom format by default
- Add
:only
and:except
options toXlsxReader.sheets/2
andXlsxReader.async_sheets/3
- Add
XlsxReader.async_sheets/3
- Speed-up shared string and styles lookups
- Improve compatibility with XLSX writers (Excel, Elixslx, …) which completely omit empty cells in worksheets
- Add
String
number type to disable numeric conversions
- Improve handling of whitespace in shared strings
- Initial release