列/索引的pandas样式set_table_styles不适用于to_excel

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

# 创建一个示例的pandas表格
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [28, 32, 25],
        'City': ['New York', 'Paris', 'London']}
df = pd.DataFrame(data)

# 创建一个Workbook对象
wb = Workbook()
ws = wb.active

# 将pandas表格的数据写入到Excel文件中
for r in dataframe_to_rows(df, index=False, header=True):
    ws.append(r)

# 设置单元格的样式
fill = PatternFill(start_color="FFFF00", end_color="FFFF00", fill_type="solid")
font = Font(color="FF0000", bold=True)
border = Border(left=Side(border_style="thin", color="000000"),
                right=Side(border_style="thin", color="000000"),
                top=Side(border_style="thin", color="000000"),
                bottom=Side(border_style="thin", color="000000"))

for row in ws.iter_rows(min_row=2, max_row=ws.max_row, min_col=1, max_col=ws.max_column):
    for cell in row:
        cell.fill = fill
        cell.font = font
        cell.border = border

# 保存Excel文件
wb.save('output.xlsx')