使用pandas将边框添加到excel

pip install openpyxl

import pandas as pd

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

# 将DataFrame写入Excel文件
writer = pd.ExcelWriter('output.xlsx', engine='openpyxl')
df.to_excel(writer, sheet_name='Sheet1', index=False)

# 打开Excel文件
workbook = writer.book
worksheet = workbook['Sheet1']

# 添加边框
border = openpyxl.styles.Border(left=openpyxl.styles.Side(style='thin'),
                               right=openpyxl.styles.Side(style='thin'),
                               top=openpyxl.styles.Side(style='thin'),
                               bottom=openpyxl.styles.Side(style='thin'))

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

# 保存Excel文件
writer.save()