All Versions
11
Latest Version
Avg Release Cycle
28 days
Latest Release
338 days ago

Changelog History
Page 1

  • v2.3.1 Changes

    November 22, 2020
    • 🛠 Fix error handling in getWorksheets #32. Thanks to @santiq!
  • v2.3.0 Changes

    October 20, 2020
    • ➕ Added numberFormat option which allows to choose which number formatting to use:
      • standard - used by default;
      • excel - number formatting used by Excel;
      • Custom dictionary object where key is the format that needs to be overriden and value is the new format to use.
  • v2.2.0 Changes

    September 23, 2020
    • 👌 Support files created by OpenXML (where tags are prefixed with x namespace) #27.
    • 🛠 Fix incorrect mapping of sheets. Now they are mapped by internal XLSX rId.
    • 🛠 Fix exception if styles.xml is missing.
  • v2.1.2 Changes

    September 10, 2020
    • ⚡️ Update ssf dependency #24.
  • v2.1.1 Changes

    August 14, 2020
    • 🛠 Fix incorrect parsing of cell with leading zeroes #21.

    Having this table

    0000 0

    before fix resulted in:

    {raw: { obj: { A: 0, B: 0 }, arr: [0, 0] },formatted: { obj: { A: 0, B: 0 }, arr: [0, 0] },header: []}
    

    and after:

    {raw: { obj: { A: '0000', B: 0 }, arr: ['0000', 0] },formatted: { obj: { A: '0000', B: 0 }, arr: ['0000', 0] },header: []}
    
  • v2.1.0 Changes

    July 28, 2020
    • withHeader now accepts a 0-based number which tells where header is located.
  • v2.0.1 Changes

    June 13, 2020
    • 🛠 Fix incorrect handling of single shared string value #18.
  • v2.0.0 Changes

    May 22, 2020

    BREAKING CHANGES

    • getWorksheets emits now object with name and hidden fields instead of simple string.

    Before:

    const sheets = await getWorksheets({filePath: './sheet.xlsx',});console.log(sheets); // ["Sheet1", "Sheet2"]
    

    After:

    const sheets = await getWorksheets({filePath: './sheet.xlsx',});console.log(sheets); // [{ "name": "Sheet1", "hidden": false }, { "name": "Sheet2", "hidden": false }]
    
  • v1.3.0 Changes

    April 10, 2020
    • 👌 Support inline strings. Thanks to @gkostov.
  • v1.2.0 Changes

    April 09, 2020
    • Header uniqueness. Now, if duplicated header name is found, column name will be prepended with column letter to maintain uniqueness.
    • ➕ Added fillMergedCells option. If true, merged cells will have the same value (by default, only the first cell of merged cells is filled with value).
      Warning! Enabling this feature may increase streaming time because file must be processed to detect merged cells before actual stream.