下载exceljs地址
1、git:https://github.com/exceljs/exceljs.git
2、码云地址:https://gitee.com/mirrors/exceljs
文档很全面只要按照步骤就没有问题
1、index.js 内容
const ExcelJS = require(‘exceljs’);
async function ddd() {
console.log(111)
const wb = new ExcelJS.Workbook();
const Sheet1 = wb.addWorksheet(‘Sheet1’);
const Sheet2 = wb.addWorksheet(‘Sheet2’);
const test = wb.addWorksheet(‘test’);
//表2 性别
Sheet2.columns = [{
header: '性别',
key: 'sex',
width: 20
},
{
header: '性别值',
key: 'sexVal',
width: 20
},
];
const Sheet2_data = [{
sex: '女',
sexVal: '0',
}, {
sex: '男',
sexVal: '1',
}];
Sheet2.addRows(Sheet2_data);
// 添加性别管理器
const _data = Sheet2_data.reduce((p, c) &#