使用名称将数据帧打印到excel

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

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

wb = Workbook()
ws = wb.active

for col_num, column_title in enumerate(df.columns, 1):
    ws.cell(row=1, column=col_num, value=column_title)

for row in dataframe_to_rows(df, index=False, header=False):
    ws.append(row)

wb.save('dataframe.xlsx')