查找两个大小相同的行之间的最大差异，同时忽略Excel中的空单元格

import openpyxl

def find_max_difference(file_path, sheet_name, row_a, row_b):
    # 打开Excel文件
    workbook = openpyxl.load_workbook(file_path)
    # 选择指定的工作表
    sheet = workbook[sheet_name]
    
    max_difference = 0
    
    # 遍历两行的每个单元格
    for cell_a, cell_b in zip(sheet[row_a], sheet[row_b]):
        # 获取单元格的值
        value_a = cell_a.value
        value_b = cell_b.value
        
        # 如果两个单元格都不为空
        if value_a is not None and value_b is not None:
            # 计算差值的绝对值
            difference = abs(value_a - value_b)
            # 更新最大差异
            if difference > max_difference:
                max_difference = difference
    
    return max_difference

# 示例用法
file_path = 'example.xlsx'
sheet_name = 'Sheet1'
row_a = 'A1:Z1'
row_b = 'A2:Z2'

max_difference = find_max_difference(file_path, sheet_name, row_a, row_b)
print("最大差异为:", max_difference)