node将MongoDB里的数据导出（下载）

在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);

})