Python ExcelWriter格式化‘所有边框’

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

# 创建一个DataFrame
data = {'Name': ['John', 'Mike', 'Sarah'],
        'Age': [28, 32, 25],
        'City': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

# 创建一个ExcelWriter对象
writer = pd.ExcelWriter('output.xlsx', engine='openpyxl')

# 将DataFrame写入Excel文件
df.to_excel(writer, sheet_name='Sheet1', index=False)

# 获取工作簿对象
workbook = writer.book

# 获取工作表对象
worksheet = writer.sheets['Sheet1']

# 创建边框样式
border_style = Border(left=Side(border_style='thin'),
                      right=Side(border_style='thin'),
                      top=Side(border_style='thin'),
                      bottom=Side(border_style='thin'))

# 获取所有单元格范围
cell_range = worksheet['A1':'C4']

# 设置边框样式
for row in cell_range:
    for cell in row:
        cell.border = border_style

# 保存Excel文件
writer.save()