将一个数据帧保存到同一Excel中的多个工作表

import pandas as pd
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows

workbook = Workbook()

data = {'姓名': ['张三', '李四', '王五'],
        '年龄': [25, 30, 35],
        '性别': ['男', '女', '男']}
df = pd.DataFrame(data)

# 创建第一个工作表并将数据帧保存到其中
worksheet1 = workbook.active
worksheet1.title = '工作表1'
for row in dataframe_to_rows(df, index=False, header=True):
    worksheet1.append(row)

# 创建第二个工作表并将数据帧保存到其中
worksheet2 = workbook.create_sheet(title='工作表2')
for row in dataframe_to_rows(df, index=False, header=True):
    worksheet2.append(row)

workbook.save('dataframe.xlsx')