```python import openpyxl from openpyxl.styles import Font # 定义需要比对的列对 col_pairs = [ ('PL_CAP-X', 'PL_CAP-Y'), ('P_ONLINE-X', 'P_ONLINE-Y'), ('LIMIT_DL-X', 'LIMI-DLY'), ('LIMITT-X', 'LIMITT-Y'), ('LMITTBKK-X', 'LMITTBKK-Y'), ('LIMITTJX/X', 'LIMIJX/Y'), ('LIMITTBARL-X', 'LIMITTBRL-Y'), ('LIMITTTSQ/X', 'LIMITSQ/Y'), ('LIMITTBWTJ/X', 'LIMITTBWTJY/'), ('LIMITSCH/X', 'LIMISCHY/'), ('LMIIJC X', 'LMIIJC Y') ] # 打开 Excel 文件 workbook = openpyxl.load_workbook('202501_pv_diff.xlsx') sheet = workbook.active # 获取表头，确定列索引 header = [cell.value for cell in sheet[1]] col_index_pairs = [] for col1_name, col2_name in col_pairs: if col1_name in header and col2_name in header: col1_index = header.index(col1_name) col2_index = header.index(col2_name) col_index_pairs.append((col1_index, col2_index)) # 定义红色字体样式 red_font = Font(color='FF0000') # 从第二行开始遍历 for row in sheet.iter_rows(min_row=2): for col1_index, col2_index in col_index_pairs: cell1 = row[col1_index] cell2 = row[col2_index] # 检查单元格是否为空 if cell1.value is not None and cell2.value is not None: try: # 将单元格值转换为数字 num1 = float(cell1.value) num2 = float(cell2.value) # 计算差值的绝对值 diff = abs(num1 - num2) # 如果差值绝对值大于等于 1，将两列数据标红 if diff >= 1: cell1.font = red_font cell2.font = red_font except ValueError: continue # 保存修改后的文件 workbook.save('202501_pv_diff.xlsx') ```