def write_report(self, url, params, expect, actual, flag): open_file = Tool.read_excel("report") table = open_file.sheets()[0] n = table.nrows wb = copy(open_file) write_sheet = wb.get_sheet(0) params = json.dumps(params, ensure_ascii=False) # 默认不将中文编码 # print("写报告测试参数", params) expect = json.dumps(expect, ensure_ascii=False) expect = Tool.json_converted_str(expect) # print("写报告期望结果", expect) actual = json.dumps(actual, ensure_ascii=False) actual = Tool.json_converted_str(actual) # print("写报告实际结果", actual) style = xlwt.easyxf('align: wrap on') # 数据写入excel自动换行 write_sheet.col(2).width = (30 * 367) write_sheet.col(3).width = (30 * 367) write_sheet.write(n, 0, url) write_sheet.write(n, 1, params) write_sheet.write(n, 2, expect, style) write_sheet.write(n, 3, actual, style) # result_sheet.write(0, 1, txt1.decode('utf-8')) if flag == 1: write_sheet.write(n, 4, u"测试通过") print("测试通过") else: write_sheet.write(n, 4, u"测试失败") print("测试失败") wb.save(r"../test_report/report.xls")
def write_report(self,url, interface_name,interface_description,params, expect, actual, flag): open_file = Tool.read_excel("report") table = open_file.sheets()[0] n = table.nrows wb = copy(open_file) write_sheet = wb.get_sheet(0) params = json.dumps(params, ensure_ascii=False) # 默认不将中文编码 expect = json.dumps(expect, ensure_ascii=False) expect = Tool.json_converted_str(expect) actual = json.dumps(actual, ensure_ascii=False) actual = Tool.json_converted_str(actual) style = xlwt.easyxf('align: wrap on') # 数据写入excel自动换行 write_sheet.col(2).width = (30 * 367) write_sheet.col(3).width = (30 * 367) write_sheet.write(n, 0, url) write_sheet.write(n, 1, interface_name) write_sheet.write(n, 2, interface_description) write_sheet.write(n, 3, params) write_sheet.write(n, 4, expect, style) write_sheet.write(n, 5, actual, style) Tool.log('URL:' + str(url), 'test') Tool.log('接口名字:' + str(interface_name), 'test') Tool.log('期望结果:'+str(expect),'test') Tool.log('实际结果:' + str(actual), 'test') if flag == 1: write_sheet.write(n, 6, u"测试通过") Tool.log("测试通过",'test') print("测试通过") else: write_sheet.write(n, 6, u"测试失败") Tool.log("测试失败", 'test') print("测试失败") wb.save(r"../test_report/report.xls")