csv-lite-js

1.1.0 • Public • Published

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

Dependents (1)

Package Sidebar

Install

npm i csv-lite-js

Weekly Downloads

3

Version

1.1.0

License

MIT

Unpacked Size

43.1 kB

Total Files

16

Last publish

Collaborators

  • kujirahand