node package manager

xlsx-export

Streaming json to xlsx converter

xlsx-export

very basic node js streaming json -> xlsx converter

Based on functionscope https://www.npmjs.org/package/excel-export

test

npm test

Usage

 
var XlsxExport = require('xlsx-export');
var collection = mongo.collection('someCollection');
 
var options = {
map: {
'date': 'date',
'number': 'number',
'name': 'string'
},
headers: [
{width: 15, caption: "Awesome Date"},
{width: 25, caption: 'Super awesome Number'},
{width: 40, caption: 'Super Name'}
],
stream: collection.stream()
};
 
var packer = new XlsxExport(options);
var stream = packer.pipe(fs.createWriteStream('./test_spread_sheet.xlsx'));
 
//todo: enjoy!