excel-stream alternatives and similar modules
Based on the "Parsing" category
-
markdown-it
A very fast markdown parser with 100% CommonMark support, extensions and syntax plugins. -
Awesome phonenumber parser
Google's libphonenumber pre-compiled with the closure compiler -
Stylecow
Parse, manipulate and convert modern CSS to make it compatible with all browsers. Extensible with plugins. -
docx-to-pdf-on-AWS-Lambda
Microsoft Word doc/docx to PDF conversion on AWS Lambda using Node.js
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest. Visit our partner's website for more details.
Do you think we are missing an alternative of excel-stream or a related project?
README
excel-stream
A stream that converts excel spreadsheets into JSON object arrays.
Examples
// stream rows from the first sheet on the file
var excel = require('excel-stream')
var fs = require('fs')
fs.createReadStream('accounts.xlsx')
.pipe(excel()) // same as excel({sheetIndex: 0})
.on('data', console.log)
// stream rows from the sheet named 'Your sheet name'
var excel = require('excel-stream')
var fs = require('fs')
fs.createReadStream('accounts.xlsx')
.pipe(excel({
sheet: 'Your sheet name'
}))
.on('data', console.log)
stream options
The options object may have the same properties as csv-stream and these two additional properties:
sheet: the name of the sheet you want to stream. Case sensitive.sheetIndex: the sheet number you want to stream (0-based).
Usage
npm install -g excel-stream
excel-stream < accounts.xlsx > account.json
options
newline delimited json:
excel-stream --newlines
formats
each row becomes a javascript object, so input like
foo, bar, baz
1, 2, 3
4, 5, 6
will become
[{
foo: 1,
bar: 2,
baz: 3
}, {
foo: 4,
bar: 5,
baz: 6
}]
Don't Look Now
So, excel isn't really a streamable format. But it's easy to work with streams because everything is a stream. This writes to a tmp file, then pipes it through the unfortunately named j then into csv-stream
License
MIT
*Note that all licence references and agreements mentioned in the excel-stream README section above
are relevant to that project's source code only.