npm install mongo-xlsx -S
var mongoXlsx = require('mongo-xlsx');
var data = [ { name : "Peter", lastName : "Parker", isSpider : true } ,
{ name : "Remy", lastName : "LeBeau", powers : ["kinetic cards"] }];
//导出xlsx标头，可自定义
var model = mongoXlsx.buildDynamicModel(data);
//生成xlsx表格
mongoXlsx.mongoData2Xlsx(data, model, function(err, data) {
console.log('File saved at:', data.fullPath);
});
//读取xlsx数据
mongoXlsx.xlsx2MongoData("./file.xlsx", model,function(err,mongoData) {
console.log('Mongo data:', mongoData);
});
网友评论