excel-stream alternatives and similar modules
Based on the "Parsing" category.
Alternatively, view excel-stream alternatives based on common mentions on social networks and blogs.
-
-
-
markdown-it
Markdown parser, done right. 100% CommonMark support, extensions, syntax plugins & high speed -
-
-
-
-
-
-
-
-
parse5
HTML parsing/serialization toolset for Node.js. WHATWG HTML Living Standard (aka HTML5)-compliant. -
-
fast-xml-parser
Validate XML, Parse XML and Build XML rapidly without C/C++ based libraries and no callback. -
-
-
-
xlsx-populate
Excel XLSX parser/generator written in JavaScript with Node.js and browser support, jQuery/d3-style method chaining, encryption, and a focus on keeping existing workbook features and styles in tact. -
-
-
-
-
json-query
DISCONTINUED. Retrieves values from JSON objects for data binding [GET https://api.github.com/repos/auditassistant/json-query: 404 - Not Found // See: https://docs.github.com/rest/repos/repos#get-a-repository] -
-
-
-
-
-
-
-
-
Civic Auth - Auth in Less Than 5 Minutes
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
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.