https://github.com/zeMirco/json2csv
http://www.cnblogs.com/cjingzm/p/3196424.html
//第一步引入模块
var json2csv = require('json2csv');var fs = require('fs');var Csv = require('csv');var crypto = require('crypto');var iconv = require('iconv-lite');
//第二步
{ method: ['get'], path: '/export/{excelname}', config: { tags: ['api'], description: '将物业托管信息导出到excel', notes: '好好', validate: { params: joi.object({ excelname: joi.string().description('批次名称'), }), failAction: FailAction } }, handler: (request, reply) => { var cookie = request.state; const excelname = request.params.excelname; if(cookie.ymciadmin) { let accountobj = JSON.parse(security.aes.decrypt(cookie.ymciadmin)); if(accountobj.type!=0||accountobj.state==0) { return reply({ code:563, msg:"你没有导出的权限！", data:{} }) } var filter = {}; Estate.readAll(filter, (err, result) => { if(result.length == 0) { return reply({ code: 530, msg: '物业托管表无数据！', data: null }); } else { let data=[]; data[0]={"_id":"序号","name":"姓名","IDCard":"身份证","mobile":"电话号码","estateproject":"project","estatenumber":"编号"} for(var i=0;i<result.length;i++) { data[i+1]=result[i]; } Csv.stringify(data, { columns: ['_id','name','IDCard','mobile','estateproject','estatenumber'] }, (err, output) => { if(err) { return reply({ code: 400, msg: "下载出错！！！", data: null }); } output = output.replace(/\"/g, "") // return reply(output) // const buffer = new Buffer(output, 'utf8'); // const str = iconv.encode(buffer, 'gb2312'); reply(output.toString('binary')).type('text/csv').header('Content-Disposition', `attachment;filename=${excelname}.csv`); });
} }) } else { reply({ code: 510, msg: '登录超时,请重新登录！', data: null }); }
}
},
转载于:https://www.cnblogs.com/luoliangfei/p/7339031.html
相关资源：数据结构—成绩单生成器