All Versions
11
Latest Version
Avg Release Cycle
28 days
Latest Release
1244 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.