simple-xlsx-reader

A utility to read xlsx files through NodeJS Stream.

Instalation

npm i simple-xlsx-reader --save

Usage

const { Writable } = require('stream')
const fs = require('fs')
const { xlsxParser } = require('simple-xlsx-reader')

const write = (fn) => {
  return new Writable({
    objectMode: true,
    write (chunk, _, callback) {
      fn(chunk)
      callback()
    }
  })
}

fs.createReadStream('path to xlsx file'))
  .pipe(xlsxParser())
  .pipe(write((row) => {
    console.log('XLSX Row', row)
  }))

To return in array of arrays format, you can use onlyCellValues function that get only values of cells.

const { Writable } = require('stream')
const fs = require('fs')
const { xlsxParser, onlyCellValues } = require('simple-xlsx-reader')

const write = (fn) => {
  return new Writable({
    objectMode: true,
    write (chunk, _, callback) {
      fn(chunk)
      callback()
    }
  })
}

fs.createReadStream('path to xlsx file'))
  .pipe(xlsxParser(onlyCellValues()))
  .pipe(write((row) => {
    console.log('XLSX Row', row)
  }))