v.2.3.0

• 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.

v.2.2.0

• 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.

v.2.1.2

• Update ssf dependency #24.

v.2.1.1

• 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: []
}

v.2.1.0

• withHeader now accepts a 0-based number which tells where header is located.

v.2.0.1

• Fix incorrect handling of single shared string value #18.

v.2.0.0

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

• Support inline strings. Thanks to @gkostov.

v1.2.0

• 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.

v1.1.0

• Add ability to effeciently stream multiple sheets from one XLSX file. Thanks to @achekanov.