easywxcel导出多个sheet
时间: 2023-09-28 08:07:22 浏览: 27
要在一个Excel文件中导出多个sheet,可以使用 easywxcel 库中的 `add_sheet()` 方法。该方法可以在已有的Excel文件中添加一个新的sheet,并返回新的sheet对象。具体步骤如下:
1. 创建一个 `ExcelWriter` 对象:
```python
from easywxcel import ExcelWriter
writer = ExcelWriter('example.xlsx')
```
2. 使用 `add_sheet()` 方法添加多个sheet:
```python
# 添加第一个sheet
sheet1 = writer.add_sheet('Sheet1')
sheet1['A1'] = 'This is Sheet1!'
# 添加第二个sheet
sheet2 = writer.add_sheet('Sheet2')
sheet2['A1'] = 'This is Sheet2!'
```
3. 最后,使用 `save()` 方法保存Excel文件:
```python
writer.save()
```
完整代码示例:
```python
from easywxcel import ExcelWriter
# 创建ExcelWriter对象
writer = ExcelWriter('example.xlsx')
# 添加第一个sheet
sheet1 = writer.add_sheet('Sheet1')
sheet1['A1'] = 'This is Sheet1!'
# 添加第二个sheet
sheet2 = writer.add_sheet('Sheet2')
sheet2['A1'] = 'This is Sheet2!'
# 保存Excel文件
writer.save()
```