openpyxl条件行格式设置已关闭一行

from openpyxl import Workbook
from openpyxl.styles import PatternFill
from openpyxl.styles.differential import DifferentialStyle
from openpyxl.formatting.rule import Rule

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

# 添加一些数据
ws['A1'] = 'Name'
ws['B1'] = 'Age'
ws['A2'] = 'John'
ws['B2'] = 25
ws['A3'] = 'Alice'
ws['B3'] = 30

# 创建一个条件格式规则
fill = PatternFill(start_color="FFFF00", end_color="FFFF00", fill_type="solid")
diff_style = DifferentialStyle(fill=fill)
rule = Rule(type="expression", dxf=diff_style)
rule.formula = ['$B2>25']  # 条件：Age大于25
ws.conditional_formatting.add('A2:B3', rule)  # 应用规则到指定范围

# 关闭一行的条件行格式设置
ws.conditional_formatting.remove(ws['A2:B2'])

# 保存工作簿
wb.save('example.xlsx')