excel 高效的文本替换！内容替换

from openpyxl import load_workbook


def replace_in_excel(file_path, old_value, new_value, split_row=49):
    try:
        # 加载Excel文件
        workbook = load_workbook(file_path)
        sheet = workbook.active  # 默认选择活动的工作表

        # 遍历所有行
        for row in sheet.iter_rows():
            # 获取当前行号
            row_number = row[0].row

            # 如果行号小于49，遍历所有单元格
            if row_number < split_row:
                for cell in row:
                    # 如果单元格的值为old_value，替换为new_value
                    if cell.value == old_value:
                        cell.value = new_value
            else:
                # 行号大于或等于49，只检查D和F列
                for col in ('D', 'F'):
                    cell = sheet[col + str(row_number)]  # 拼接单元格地址
                    # 如果单元格的值为old_value，替换为new_value
                    if cell.value == old_value:
                        cell.value = new_value

        # 保存修改后的Excel文件
        workbook.save(file_path)

        print("替换操作完成。")

    except Exception as e:
        print(f"替换操作出错：{e}")