Python openpyxl条件格式containsText

from openpyxl import Workbook
from openpyxl.styles import PatternFill
from openpyxl.styles.differential import DifferentialStyle
from openpyxl.styles import Font
from openpyxl.styles import Alignment
from openpyxl.styles import Border, Side

# 创建一个新的工作簿
wb = Workbook()

# 选择活动工作表
ws = wb.active

# 添加一些数据
ws['A1'] = 'Hello'
ws['A2'] = 'World'
ws['A3'] = 'Python'
ws['A4'] = 'openpyxl'
ws['A5'] = 'containsText'

# 创建一个条件格式对象
dxf = DifferentialStyle(fill=PatternFill(start_color="FFFF00", end_color="FFFF00"))

# 创建一个规则对象
rule = Rule(type="containsText", operator="containsText", formula1='"Python"', dxf=dxf)

# 将规则对象应用到工作表的范围
ws.conditional_formatting.add("A1:A5", rule)

# 保存Excel文件
wb.save("example.xlsx")