node-csv-lite

CSV Reader/Writer for Node.js

When you use browser, you can use csv-lite-js.

Install

``
$ npm install csv-lite
`

Usage

Simple static method:

`javascript
var CSV = require('csv-lite');

// parse CSV string
var txt = "1,2,3\n11,22,33\n111,222,333";
var a = CSV.parse(txt);
console.log(a[0][0]); // 1
console.log(a[1][1]); // 22

// load from file
var a = CSV.readFileSync("test.csv", "Shift_JIS");
// save to file
CSV.writeFileSync("test.csv", a, "Shift_JIS");
`

OOP method:

`javascript
var CSVObject = require('csv-lite').CSVObject;

var csv = new CSVObject();
csv.parse("name,age\r\nAki,14\r\nHuyu,20");
console.log(csv.getCell(1,0)); // Aki
console.log(csv.getCell(2,0)); // Huyu

// save
csv.writeFileSync("test.csv", "Shift_JIS")

// load
csv.readFileSync("test.csv", "Shift_JIS");
console.log(csv.getCell(1,0)); // Aki
`

Parse and Stringify

method:

- CSV.parse()
- CSV.stringify()

Parse CSV from text

`javascript
var csv = "a,b,c\nd,e,f";
var a = CSV.parse(csv);
console.log(a[0][0]); // a
console.log(a[0][1]): // b
console.log(a[1][0]); // d
console.log(a[1][1]): // e
`

Stringify Array to CSV

`javascript
var a = [[1,2,3],[4,5,6]]
var c = CSV.stringify(a);
console.log(c); // 1,2,3\n4,5,6
`

Load from file

- CSV.readFileSync(filename, encoding)
- CSV.readFile(filename, encoding, callback)

Save to file

- CSV.writeFileSync(filename, data_ary, encoding)
- CSV.writeFile(filename, encoding, callback)

TSV (Tab separated value)

`javascript
// set tsv option
CSV.options.delimiter = "\t";
// load
var a = CSV.readFileSync(fname);
`

OOP method

- CSVObject.toString()
- CSVObject.parse(csv_str, delimiter)
- CSVObject.getCell(row, col)
- CSVObject.setCell(row, col, value)
- CSVObject.setArray( array )
- CSVObject.getArray()
- CSVObject.find(colNo, keyword, offset)
- CSVObject.findAll(colNo, keyword)
- CSVObject.findAll(colNo, keyword, offset, limit)
- CSVObject.filter(colNo, callback)
- CSVObject.sort(colNo, isAsc)
- CSVObject.sortNumber(colNo, isAsc)
- CSVObject.insertRow(rowNo, rowArray)
- CSVObject.insertCol(colNo, values)
- CSVObject.deleteRow(rowNo)
- CSVObject.deleteCol(colNo)
- CSVObject.add(rowArray)
- CSVObject.length
- CSVObject.useHeader

Test module

`
$ mocha test/simple.js
``