如何将pandas DataFrame样式化为excel文件

import pandas as pd
from openpyxl.styles import Font, Color, PatternFill, Border, Side
from openpyxl import Workbook

# 创建一个示例DataFrame
data = {'Name': ['John', 'Emma', 'Peter'],
        'Age': [25, 28, 30],
        'City': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

# 创建一个Excel文件和工作表
workbook = Workbook()
sheet = workbook.active

# 将DataFrame数据写入Excel文件
for r in dataframe_to_rows(df, index=False, header=True):
    sheet.append(r)

# 样式化Excel文件
header_font = Font(bold=True)
header_fill = PatternFill(fill_type='solid', fgColor='CCCCCC')
border = Border(left=Side(style='thin'), 
                right=Side(style='thin'), 
                top=Side(style='thin'), 
                bottom=Side(style='thin'))

# 设置表头样式
for cell in sheet[1]:
    cell.font = header_font
    cell.fill = header_fill
    cell.border = border

# 保存Excel文件
workbook.save('styled_dataframe.xlsx')