在routes文件夹:xxx.js
//这里需要引入数据库模块
const {accountModel} =require("../dao/models/accountModels")//数据库模块样式在请查看上次的作品
// 下载文件
router.get('/exportExcel',async (req,res) => {
let data = [];
let title = ['邮箱', '密码', '姓名','绑定手机1','绑定手机2','TeamID','账号注册时间','账号注册渠道','初始电话号码','备注1','备注2','备注3'];
data.push(title);
let result = await accountModel.find();
result.forEach(item => {
let arrInner = [];
arrInner.push(item.accountnumber);
arrInner.push(item.password);
arrInner.push(item.names);
arrInner.push(item.phone1);
arrInner.push(item.phone2);
arrInner.push(item.teamid);
arrInner.push(item.registrationtime);
arrInner.push(item.registeredchannels);
arrInner.push(item.initialphonenum);
arrInner.push(item.remark1);
arrInner.push(item.remark2);
arrInner.push(item.remark3);
data.push(arrInner);
});
let buffer = xlsx.build([
{
name:'sheet1',
data:data
}
]);
console.log(buffer);
res.send(buffer);
})