import xlrd,requests,openpyxl,json
from xlutils.copy import copy
def gettestdatakey():
table =xlrd.open_workbook('testcase.xlsx')
data = table.sheet_by_name('paramslogin')
checkres = data.row_values(0)
if 'Result' in data.row_values(0):
return checkres[0:checkres.index('Result')]
else:
return checkres
def gettestdatavalue():
array = []
table = xlrd.open_workbook('testcase.xlsx')
data = table.sheet_by_name('paramslogin')
for i in range(1,data.nrows):
array.append(data.row_values(i))
return array
def gettestdatadict():
tmpvalue = gettestdatavalue()
tmpkey = gettestdatakey()
dictdata = []
for i in tmpvalue:
dictdata.append(dict(zip(tmpkey,i)))
return dictdata
def gettestresult(resultdata):
rb = xlrd.open_workbook('testcase.xlsx','w+b')
rs = rb.sheet_by_name('paramslogin')
cols = rs.ncols
wb = copy(rb)
data = wb.get_sheet(1)
for i in range(rs.nrows):
if i == 0:
data.write(0, cols, 'Result')
else:
if resultdata[i - 1]['message'] == '成功':
data.write(i,cols,'pass')
else:
data.write(i, cols, str(resultdata[i - 1]))
wb.save('testcase.xlsx')