All Versions
Latest Version
Avg Release Cycle
Latest Release

Changelog History
Page 2

  • v1.3.6 Changes

    • โž• Added boolean value support. Thanks to Pikender Sharma (@pikender) for contribution.
    • โž• Added support for data type inlineStr.
    • ๐Ÿ‘ป Xlsxir.extract/3 and Xlsxir.multi_extract/3 now return {:error, reason} instead of throwing an exception when an invalid file type or worksheet index are provided as arguments.
    • ๐Ÿ”„ Changed the way file paths are validated prior to parsing. It no longer matters whether or not the extension is .xlsx. As long as it is a valid file, Xlsxir will attempt to parse it.
    • ๐Ÿ”จ Refactored Unzip.delete_dir/1 for simplification.
    • ๐Ÿ“š Minor documentation updates.
  • v1.3.5 Changes

    • ๐Ÿ›  Fixed bug where unnecessary cells with nil values were added to worksheets with rows containing data beyond column "Z".
  • v1.3.4 Changes

    • ๐Ÿ›  Fixed bug related to parsing a worksheet containing conditional formatting. Thanks to Justin Nauman (@jrnt30) for contribution.
    • ๐Ÿ›  Fixed bug where row number was erroneously represented as a string (instead of integer) in the ETS table causing Enum.sort to not work as expected on larger files.
    • ๐Ÿ“š Minor documentation updates.
  • v1.3.3 Changes

    • ๐Ÿ›  Minor bug fixes.
  • v1.3.2 Changes

    • ๐Ÿ›  Fixed bug where dates in the year 1900 were off by one day due to the fact that Excel erroneously considers the year 1900 a leap year.
    • ๐Ÿ“š Minor documentation updates.
  • v1.3.1 Changes

    • ๐Ÿ›  Fixed issue where empty cells were skipped. Empty cells will now be represented as nil. For example, if cells "A1" = 1, "B1" = 2, and "D1" = 4, Xlsxir.get_list/1 would return [[1, 2, 4]]. The same situation will now return [[1, 2, nil, 4]] to account for the fact that cell "C1" was empty.
    • ๐Ÿ“š Minor updates to documentation to reflect change.
  • v1.3.0 Changes

    • โž• Added ability to parse multiple worksheets via Xlsxir.multi_extract/3 which returns a unique table identifier for each ETS process created, enabling the user to access parsed data from multiple worksheets simultaneously.
    • Created an Xlsxir.TableId module which controls an agent process that temporarily holds a table identifier during the extraction process.
    • ๐Ÿ”จ Refactored Xlsxir access functions to work with Xlsxir.multi_extract/3 whereby a table identifier is passed through the various functions to specify which ETS process is to be accessed.
    • ๐Ÿ”จ Refactored Xlsxir.SaxParser, Xlsxir.ParseWorksheet and Xlsxir.Worksheet modules to support new functionality.
    • ๐Ÿ”จ Refactored Xlsxir.ParseWorksheet to ignore empty cells.
    • ๐Ÿ“š Updated documentation and tests
    • ๐Ÿ›  Fixed a few minor bugs that were generating warning messages.
  • v1.2.1 Changes

    • โœ‚ Removed Ex-Doc and Earmark dependencies from Hex.
    • โž• Added Change Log link to Hex.
    • ๐Ÿ›  Minor doc changes and bug fixes.
  • v1.2.0 Changes

    • โž• Added Xlsxir access function Xlsxir.get_mda/0 that accesses :worksheet ETS table and returns an indexed map which functions like a multi-dimensional array in other languages.
  • v1.1.0 Changes

    • ๐ŸŽ Modified the way rows are saved to the :worksheet ETS table. Replaced the generic index with the actual row number to allow for performance imporovement of supporting Xlsxir access functions.
    • ๐ŸŽ Refactored Xlsxir access functions to improve performance.
    • Created Xlsxir.get_info/1 function which returns number of rows, columns and cells.
    • ๐Ÿ“„ Various minor modifications to docs.