node 导入数据，生成excel

1.使用node-xlsx和fs模块

2.代码如下：

let userdata = await UserModel.find({});

let alldata = [];

let row = ['id','姓名','邮箱','是否管理员'];

alldata.push(row)

for (let key in userdata) {

let arr = [];

arr.push(userdata[key].id);

arr.push(userdata[key].name);

arr.push(userdata[key].email);

arr.push(userdata[key].isAdmin);

alldata.push(arr)

}

var buffer = xlsx.build([{

name: "mySheetName",

data: alldata

}]);

fs.writeFileSync('./test.xlsx', buffer);

3.效果如下：