excelJS 导出两个sheet
时间: 2023-08-24 18:07:08 浏览: 61
,怎么写代码实现?
可以使用excelJS库创建Excel表格,并使用Workbook对象的addWorksheet方法添加多个sheet。以下是示例代码:
```
const ExcelJS = require('exceljs');
const workbook = new ExcelJS.Workbook();
const sheet1 = workbook.addWorksheet('Sheet1');
const sheet2 = workbook.addWorksheet('Sheet2');
// 添加数据到Sheet1
sheet1.columns = [
{ header: 'Name', key: 'name', width: 20 },
{ header: 'Age', key: 'age', width: 10 },
{ header: 'Gender', key: 'gender', width: 10 },
];
sheet1.addRow({ name: 'John', age: 30, gender: 'Male' });
sheet1.addRow({ name: 'Jane', age: 25, gender: 'Female' });
sheet1.addRow({ name: 'Tom', age: 40, gender: 'Male' });
// 添加数据到Sheet2
sheet2.columns = [
{ header: 'ID', key: 'id', width: 10 },
{ header: 'City', key: 'city', width: 20 },
{ header: 'Population', key: 'population', width: 15 },
];
sheet2.addRow({ id: 1, city: 'Beijing', population: 21540000 });
sheet2.addRow({ id: 2, city: 'Shanghai', population: 24180000 });
sheet2.addRow({ id: 3, city: 'Guangzhou', population: 14040000 });
// 保存为Excel文件
workbook.xlsx.writeFile('example.xlsx')
.then(() => console.log('Excel file saved.'));
```
该代码将导出一个名为example.xlsx的Excel文件,包含两个sheet:Sheet1和Sheet2。你可以根据自己的需要修改列的标题和数据。