csv-lite-js
CSV Library for Browser
Install
$ npm install csv-lite-js
Usage
Simple static method:
import CSV from 'csv-lite-js'
const txt = "1,2,3\n11,22,33\n111,222,333";
const r = CSV.parse(txt);
console.log(CSV.stringify(r));
OOP method:
var csv = new CSV.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
console.log(csv.toString())
Parse and Stringify
method:
- CSV.parse()
- CSV.stringify()
Parse CSV from text
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
var a = [[1,2,3],[4,5,6]]
var c = CSV.stringify(a);
console.log(c); // 1,2,3\n4,5,6
TSV (Tab separated value)
// set tsv option
CSV.options.delimiter = "\t";
// parse CSV string
var txt = "1\t2\t3\n11\t22\t33\n111\t222\t333";
var a = CSV.parse(txt);
console.log(a[0][0]); // 1
console.log(a[1][1]); // 22
OOP method
CSV.CSVObject has many 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