All Versions
Latest Version
Avg Release Cycle
Latest Release

Changelog History
Page 3

  • v1.0.0 Changes

    ๐ŸŽ Major changes in version 1.0.0 (non-backwards compatible) to improve performance and incorporate new functionality, including:

    • ๐Ÿ”จ Refactored the Xlsxir.Unzip module to extract .xlsx contents to file instead of memory to improve memory usage. The following functions were created to support this functionality:
      • Xlsxir.Unzip.extract_xml_to_file/2 - Extracts necessary files to a ./temp directory for use during the parsing process
      • Xlsxir.Unzip.delete_dir/1 - Deletes './temp' directory and all of its contents
    • ๐ŸŽ Implemented Simple API for XML (SAX) parsing functionalty via the Erlsom Erlang library to improve performance and allow support for large .xlsx files. The SweetXml parsing library has been deprecated from Xlsxir and is no longer utilized in v1.0.0.
    • Implemented Erlang Term Storage (ETS) for temporary storage of extracted data.
    • Replaced option argument from the initial extract function (Xlsxir.extract/3) with timer which is a boolean flag that controls Xlsxir.Timer functionality. Data is no longer returned via Xlsxir.extract/3 and is instead stored in an ETS process.
    • Implemented various functions for accessing the extracted data:
      • Xlsxir.get_list/0 - Return entire worksheet data in the form of a list of row lists
      • Xlsxir.get_map/0 - Return entire worksheet data in the form of a map of cell names and values
      • Xlsxir.get_cell/1 - Return value of specified cell
      • Xlsxir.get_row/1 - Return values of specified row
      • Xlsxir.get_col/1 - Return values of specified column
    • ๐Ÿ†“ Implemented Xlsxir.close/0 function to allow the deletion of the ETS process containing extracted worksheet data to free up memory.
    • Implemented Xlsxir.Timer module for tracking elapsed time of extraction process.
    • ๐Ÿ”„ Changed cell references from atoms to strings due to Elixir atom limitations (i.e. :A1 to "A1").
    • ๐Ÿ“š Updated documentation and testing to incorporate changes.
  • v0.0.5 Changes

    • ๐Ÿ“š Minor bug fixes and documentation updates.
  • v0.0.4 Changes

    • Expanded coverage of Office Open XML standard numFmt (Standard Number Format). The formatCode for a standard numFmt is implied rather than explicitly identified in the XML file.
    • ๐Ÿ‘ Implemented support for Office Open XML custom numFmt (Custom Number Format) utilizing the formatCode explicitly identified in the XML file.
    • โž• Added Number Styles documentation covering standard and custom numFmt and how to manually add an unsupported numFmt.
    • Fixed issue resulting when no strings exist in a worksheet and therefore there is no sharedStrings.xml file (:file_not_found error).
  • v0.0.3 Changes

    • ๐Ÿ›  Fixed issue related to strings that contain special characters. Refactored Xlsxir.Parse.shared_strings/1 to properly parse strings with special characters.
  • v0.0.2 Changes

    • ๐ŸŽ Refactored Xlsxir.Parse functions to improve extract performance on larger files.
    • ๐Ÿ“š Expanded documentation and test coverage.
    • Completed Xlsxir.ConvertDate module.
  • v0.0.1 Changes

    • ๐ŸŽ‰ Initial draft. Functionality limited to very small Excel worksheets.
    • Xlsxir.ConvertDate functionality incomplete.