def runCases():
reader = Reader()
writer = Writer()
http = HTTP(writer)
reader.open_excle('../lib/cases/HTTP接口用例.xls')
writer.copy_open('../lib/cases/HTTP接口用例.xls',
'../lib/results/result-HTTP接口用例.xls')
sheetname = writer.get_sheets()
sheetname = reader.get_sheets()
for sheet in sheetname:
# 设置当前读写都是当前sheet页面
reader.set_sheet(sheet)
writer.set_sheet(sheet)
# 默认都写在第7列
writer.clo = 7
# 遍历读取所有的sheet页面的内容
for i in range(reader.rows):
line = reader.readine()
# 如果第一列或者第二列有内容，就是分组信息，不运行
if len(line[0]) > 0 or len(line[1]) > 0:
pass
else:
print(line)
writer.row = i
func = getfunc(line, http)
lenargs = getargs(func)
run(func, lenargs, line)
writer.save_close()
if len(args) == 2:
func(line[4], line[5])
return
if len(args) == 3:
func(line[4], line[5], line[6])
return
print("warning: 目前仅支持三个以内的参数")
casename = "SOAP"
reader = Reader()
reader.open_excel("./lib/cases/" + casename + ".xls")
writer = Writer()
writer.copy_open('./lib/cases/' + casename + '.xls',
'./lib/results/' + casename + '-result.xls')
sheetnames = writer.get_sheets()
reader.readline()
caseType = reader.readline()[1]
http = None
if caseType == 'HTTP':
http = HTTP(writer)
elif caseType == 'SOAP':
http = SOAP(writer)
#开始执行时间
writer.set_sheet(sheetnames[0])
writer.write(1, 3, str(datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')))
for sheet in sheetnames:
reader.set_sheet(sheet)