#coding=utf-8
from openpyxl import load_workbook
from xlrd import open_workbook
from xlutils.copy import copy
import re
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
r_wb = open_workbook('/home/nfs/RC测试用例20240417.xls',formatting_info=True)
r_sheet = r_wb.sheet_by_name('RC')
r_wb2 = open_workbook('/home/nfs/模板数据.xls',formatting_info=True)
r_sheet2 = r_wb.sheet_by_name('template')
wb = copy(r_wb)
sheet = wb.get_sheet(0)
for i in range(1,r_sheet.nrows):
title1 = r_sheet.cell(i,1).value
title2 = r_sheet.cell(i,2).value
title3 = r_sheet.cell(i,3).value
data = '/'+title1+'/'+title2+'/'+title3 #拼接第二列、第三列、第四列数据
for i in range(r_sheet2.nrows):
module = r_sheet2.cell(i,0).value #模板里中第一列数据
if data in module: #是否在模板中中能找到
sheet.write(i,4,module)
break
wb.save('/home/nfs/RC测试用例20240417-完成.xls')
脚本-20240417-替换表格中某一列数据
最新推荐文章于 2024-07-19 16:36:18 发布