An object stream that coerces tabular data to numbers. Assumes that all incoming objects have the same set of keys and does not fill in missing values. Supports comma and dot notation (1,23 and 1.23).
npm i detect-tabular coerce-tabular jsonstream
var detect = require('detect-tabular')
, coerce = require('coerce-tabular')
, fs = require('fs')
, json = require('jsonstream')
fs.createReadStream('air_pollution_nl.xlsx')
.pipe( detect() )
.pipe( coerce() )
.pipe( json.stringify() )
.pipe( process.stdout )Returns a transform stream. Give it objects in the form of { name: "Alice", nr: "1e-2" } and get back { name: "Alice", nr: 0.01 }.
With npm do:
npm install coerce-tabular