如何使用Pandas更改Excel单元格/行的背景色？

pip install pandas openpyxl

import pandas as pd
from openpyxl.styles import PatternFill
from openpyxl import load_workbook

df = pd.read_excel('your_file.xlsx')

writer = pd.ExcelWriter('your_file.xlsx', engine='openpyxl')
df.to_excel(writer, index=False, sheet_name='Sheet1')
writer.save()

book = load_workbook('your_file.xlsx')
sheet = book['Sheet1']

cell_range = sheet['A1:B5']  # 例如，要更改A1到B5范围的背景色
fill = PatternFill(start_color="FF0000", end_color="FF0000", fill_type="solid")  # 例如，将背景色设置为红色

for row in cell_range:
    for cell in row:
        cell.fill = fill

book.save('your_file.xlsx')