node-csvjsonlite
v1.1.4
Published
Lightweight CSV to JSON for Node.JS
Downloads
6
Readme
node-csvjsonlite
###Lightweight CSV to JSON for Node.JS
Usage
var csv = require('node-csvjsonlite');
var filename = './path/to/your.csv';
// OR this can be a URL like
// filename = 'http://sample.com/data.csv';
// OR filename can be a string of CSV data
//
// Suppose your.csv is following:
//
// Date,Open,High,Low
// 2015-03-27,2.58,2.65,2.53
// 2015-03-26,2.73,2.74,2.57
// 2015-03-25,2.64,2.73,2.61
csv
.convert(filename)
// Detects whether filname is
// a local file, URL, or string of data
.then(function(successData){
console.log('CSV in JSON', successData);
// resolves to
// [{ Date: 2015-03-27, Open: 2.58, High: 2.65, Low: 2.53 },
// { Date: 2015-03-26, Open: 2.73, High: 2.74, Low: 2.57 },
// { Date: 2015-03-25, Open: 2.64, High: 2.73, Low: 2.61 }]
});
Or you can be specific
var promiseFile = csv.convertFile(filename);
var promiseURL = csv.convertURL(fileURL);
var promiseStr = csv.convertString(stringData);
Get Started
npm install node-csvjsonlite
var csv = require('node-csvjsonlite');
Features
###Bluebird as promise
Bluebird is used as promise to keep it lightweight.
###Commas within double quotes
var csv = require('node-csvjsonlite');
var filename = './path/to/your.csv';
// where your.csv has the following data:
// Date, Value
// 2015-02-14,"2,2"
// 2015-02-15,"4,3"
// 2015-02-16,"1,2"
// resolves to
// [{ Date: 2015-02-14, Value: 2,2 },
// { Date: 2015-02-15, Value: 4,3 },
// { Date: 2015-02-16, Value: 1,2 }]
###CSV from online source
var csv = require('node-csvjsonlite');
var filename = 'http://something.com';
where filename can be HTTP or HTTPS.
Note: If file does not exist, then it will reject the promise.
###Error Handling
Error will be resolved in the Promise rejection.
var csv = require('node-csvjsonlite');
var badFilename = './path/to/invalid.csv';
csv
.convert(badFilename)
.then(function(successData){
console.log('This shouldn\'t show');
}, function(errorReason){
console.log(errorReason);
// Error Reason is either a string ("File does not exist")
// or an error object returned from require('fs').readFile
});
Note that since it uses bluebird as promise, if the promise is rejected and there is no rejection handler, it will throw an error.