mg-csv-writer

csv-writer

A fast, lean CSV-WRITER for node that gives enough flexibility to create CSV files quickly and painlessly without too many hoops.

Features:

* Optional CSV file write
* Pagable results
* async / await ready
* Customizable delimiter
* Customizable column control
* Date formating
* Type overriding
* Value escaping
* Callback function for ultimate control on formatting

Installation

``
npm install mg-csv-writer
`

Usage

`
var stockData = [{
Symbol: "AAPL",
Company: "Apple Inc.",
Price: 132.5,
TradeDt: new Date()
},
{
Symbol: "INTC",
Company: "Intel Corporation",
Price: 33.45,
TradeDt: new Date()
},
{
Symbol: "GOOG",
Company: "Google Inc",
Price: 554.52,
TradeDt: new Date()
},
{
Symbol: "TLSA",
Price: 554.52,
TradeDt: new Date()
}
];

const mgCsvWriter = require("mg-csv-writer");

const csvOut = new mgCsvWriter({
outfile: "/tmp/output.csv",
header: true,
quoted: false,
lineSep : "\n",
delimiter: ",",
columns: [{
id: "Symbol",
title: "Company Name",
fnFormat: function(colData, colId, rowData) {
// so something special!
return colData;
}
},
{ id: "Company",
title: "Id",
defaultValue: "no name" },
{ id: "Price",
title: "Price",
dataType: "int",
prefix: "$" },
{ id: "TradeDt",
title: "Trade Date",
dataType: "date",
dateMask: "yyyy-mm-dd"
}
]
});

csv.writeHeader();

csv.write(stockData); // can be a single row; or an array of rows
csv.write(stockData2); // multiple calls will add to the file
``

Updates

* 2020-12-15 Renamed internal class; Updated code standard
* 2020-02-13 Added quoted attribute
* 2019-03-08 Initial Release