条件检查工作表范围python

from openpyxl import Workbook
from openpyxl.styles import PatternFill
from openpyxl.utils import get_column_letter

def apply_conditional_formatting(sheet, start_row, end_row, start_col, end_col, condition, fill_color):
    for row in range(start_row, end_row + 1):
        for col in range(start_col, end_col + 1):
            cell = sheet[get_column_letter(col) + str(row)]
            if eval(condition):
                cell.fill = PatternFill(start_color=fill_color, end_color=fill_color, fill_type="solid")

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

# 假设我们要对A1到C10的范围进行条件检查
start_row = 1
end_row = 10
start_col = 1
end_col = 3

# 假设我们要对数值大于10的单元格应用绿色填充
condition = "cell.value > 10"
fill_color = "00FF00"

# 应用条件格式
apply_conditional_formatting(sheet, start_row, end_row, start_col, end_col, condition, fill_color)

# 保存工作簿
workbook.save("conditional_formatting.xlsx")