使用Pandas/ExcelWriter对单元格中的文本部分进行着色

import pandas as pd
from openpyxl.styles import PatternFill

df = pd.DataFrame({'Column1': ['Text with color', 'Text without color']})
writer = pd.ExcelWriter('output.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Sheet1', index=False)

workbook = writer.book
worksheet = writer.sheets['Sheet1']

text_to_color = 'color'  # 要着色的文本
color = 'FFFF00'  # 着色的颜色，这里使用黄色作为示例

for row in range(1, worksheet.max_row + 1):
    for col in range(1, worksheet.max_column + 1):
        cell_value = worksheet.cell(row=row, column=col).value
        if cell_value and text_to_color in str(cell_value):
            cell = worksheet.cell(row=row, column=col)
            fill = PatternFill(start_color=color, end_color=color, fill_type='solid')
            cell.fill = fill

writer.save()
writer.close()