102-excel其中一行替换另一样内容（正则）

# -*- coding:utf8 -*-
# 导入包
import re

import openpyxl

# 打开excel
excel_file = openpyxl.load_workbook(
    'E:/002-pd最新脚本2020年10月21日202455/test/esat/scripts/integration_test/frontend/bgt/fgi/012init.xlsx')
a_mubiao = re.sub(r'\d\d\_\d\d\_\d\d\d\_\d\d\d', 'ss', 'fgi_i_f_01_01_001_001_front_init_zero_r0')
print(a_mubiao)

# # 获取工作表
# sheet_list=excel_file.get_sheet_names()
# print(sheet_list)
# # # 获取
sheet1 = excel_file.get_sheet_by_name('前台初始化测试用例')
# print(sheet1.title)
# 按字母形式打开cell
print(sheet1['B15'].value)
# anothersheet = excel_file.active
# print(anothersheet)
# 获取行和列数
# get_highest_row   get_highest_column()
# 按坐标方式打开cell
# 实现（hang,1）（hang,2）数据覆盖  ps3-1.0.0-fgi-i-f-01-01-001-001    fgi_i_f_01_01_001_001_front_init_zero_r0
hang = 17
for hang in range(17,234):
    xuyaogaide = sheet1.cell(row=hang, column=1).value
    it = re.finditer(r"(\d\d\-\d\d\-\d\d\d\