1. #     EXcel定义函数
    2. def computer(data1, oper, data2):
    3.     if oper == "+":
    4.         result = data1 + data2
    5.     elif oper == "-":
    6.         result = data1 - data2
    7.     elif oper == "*":
    8.         result = data1 * data2
    9.     elif oper == "/":
    10.         result = data1 / data2
    11.     elif oper == "%":
    12.         result = data1 % data2
    13.     else:
    14.         result = -1
    15.     return result
    16. def readExcel(file,sheetIndex):
    17.     import xlrd
    18.     fp=xlrd.open_workbook(file)
    19.     case=fp.sheet_by_index(sheetIndex)
    20.     for rowID in range(0,case.nrows):
    21.         caseList.append(case.row_values(rowID))
    22.     return caseList
    24. def writeExcel(file,sheetName,content):
    25.     import xlwt
    26.     fp=xlwt.Workbook(encoding='utf-8')
    27.     case=fp.add_sheet(sheetName)
    28.     i=0
    29.     for rowInfo in content:
    30.         j=0
    31.         for cellInfo in rowInfo:
    32.             case .write(i,j,label=cellInfo)
    33.             j=j+1
    34.         i=i+1
    35.     # case.write(i,j,label=content)
    36.     fp.save(file)
    40. caseList=readExcel(r'D:\computerCases.xls',0)
    41. title=caseList.pop(0)
    42. title.extend(['Acturalresult','Status'])
    44. for case2 in caseList:
    45.     print(case2)
    46.     acResult=computer(case2[2],case2[3],case2[4])
    47.     if acResult==case2[5]:
    48.         case2.extend([acResult,'pass'])
    49.     else:
    50.         case2.extend([acResult,'fail'])
    51. caseList.insert(0,title)
    52. writeExcel(r'D:\computerCases5.xls','computerResult',caseList)
    1. # @Time    : 2022/9/1 10:45
    2. # @Author  : Andrew
    4. import xlrd,xlwt
    5. def computer(data1, oper, data2):
    6.     if oper == "+":
    7.         result = data1 + data2
    8.     elif oper == "-":
    9.         result = data1 - data2
    10.     elif oper == "*":
    11.         result = data1 * data2
    12.     elif oper == "/":
    13.         result = data1 / data2
    14.     elif oper == "%":
    15.         result = data1 % data2
    16.     else:
    17.         result = -1
    18.     return result
    19. def read_doc():
    20.     pass
    27. # # 1. 打开文件，返回文件对象
    28. # fileObj=xlwt.Workbook(encoding = 'utf-8')       #创建一个新的Excel文件
    29. # # 2. 新增一个sheet表单
    30. # sheetObj = fileObj.add_sheet('My Worksheet')  #创建一个新的worksheet
    31. # # 3. 写入表单单元格内容
    32. # sheetObj.write(行号,列号, label = '内容')
    33. # # 4. 保存表单
    34. # fileObj.save(文件名称)
    35. # fileObj.save(文件名称)
    36. report_doc = xlwt.Workbook(encoding='utf-8')   #新建一个表格文件
    37. reporrt_sheet = report_doc.add_sheet('testReport')  #新建一个表
    38. # fileObj = xlrd.open_workbook('../computerCases.xls')
    39. # sheetObj = fileObj.sheet_by_index(0)
    40. # testCase = sheetObj.row_values(0)
    41. # for i in range(0, len(testCase)):
    42. #     reporrtSheet.write(0, i, label=f'{testCase[i]}')
    43. # reportObj.save('./testReport.xls')
    45. test_doc  = xlrd.open_workbook('../computerCases.xls')   #打开测试用例文件
    46. test_sheet = test_doc.sheet_by_index(0)   #打开表1
    47. # testCase = sheetObj.row_values(0)#提取标题栏
    48. # testCase.extend(["ActuralResult","Status"]) #标题栏增加实际值和状态
    49. # for i in range(0, len(testCase)):
    50. #     reporrtSheet.write(0, i, label=f'{testCase[i]}')
    53. for i in range(0,test_sheet.nrows):  #按文件总行数进行循环
    54.     if i == 0: #当行数为0时,标题行  需要增加实际值和状态
    55.         test_Case = test_sheet.row_values(i)  # 提取标题栏为列表
    56.         test_Case.extend(["ActuralResult", "Status"])  # 标题栏增加实际值和状态
    57.         for j in range(0, len(test_Case)): #遍历标题中每个元素
    58.           reporrt_sheet.write(i, j, label=f'{test_Case[j]}')  #在报告单中输入标题栏
    59.     else:  #当  遍历到其它行时为测试用例   需要进行操作
    60.         test_Case =  test_sheet.row_values(i)  #提取测试用例
    61.         # print(len(testCase),testCase,type(testCase))
    62.         actualResult = computer(int(test_Case[2]),test_Case[3],int(test_Case[4]))#调用计算器  计算实际值
    63.         if actualResult == int(test_Case[5]): #  实际值和预期值进行比较
    64.             test_Case.extend([f'{actualResult}','pass'])  #相同时 则在用例后方添加实际值,状态
    65.         else:
    66.             test_Case.extend([f'{actualResult}','Fail'])  #不同时 则在用例后方添加实际值,状态
    67.         for j in range(0, len(test_Case)):   #将新的用例表进行遍历
    68.             reporrt_sheet.write(i, j, label=f'{test_Case[j]}')  #将新的用例表插入到报告文件中
    69. report_doc.save('./testReport.xls')
    73.     # for i in  range (0,sheetObj.nrows):