用例大概有500条,但同一个单元格中有操作步骤、预期结果,现在要将操作步骤和预期结果拆分,放到不同列,便于管理。
#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/测试用例0425.xls',formatting_info=True)
r_sheet = r_wb.sheet_by_name('Sheet1')
result_line = r_sheet.nrows
wb = copy(r_wb)
sheet = wb.get_sheet(0)
for i in range(result_line):
value = r_sheet.cell(i,3).value
#print value
data = re.match(r'[\s\S]*操作步骤[::]*([\s\S]*)预期结果[::]*([\s\S]*)',str(value)) #提取数据
if data:
sheet.write(i,4,data.group(1).strip('\n').decode('utf-8'))
sheet.write(i,5,data.group(2).strip('\n').decode('utf-8'))
wb.save('/home/nfs/测试用例-拆分后.xls')
else:
print('未找到哦!!')