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