def fuzz_case_write(fuzz_case_data): # 尝试打开path下的FuzzCase.xlsx文件,若没有,则新建 path = MyExcel.current_path() + "\\FuzzCase.xlsx" try: fuzz_workbook, fuzz_sheet = MyExcel.read_excel(path) except IOError, e: logger.debug(u"fuzz_test,尝试打开指定路径文件失败 %s" % str(e)) if "Errno 2" in str(e): fuzz_workbook, fuzz_sheet = MyExcel.read_excel() fuzz_workbook.save(path)
def case_generate(): """ 从TestConfig中读取配置指定的表格,返回按行输出的生成器 配置应包含表格文件路径以及工作表名称 """ logger.debug('enter case_generate') logger_output.debug('enter case_generate') workbook,sheet = MyExcel.read_excel(TestConfig.excel_case_path[0],TestConfig.excel_case_path[1]) case_list = list(sheet.rows) case_list.pop(0) #去除标题行 logger.debug('count of case :%s'%len(case_list)) for case in case_list: yield case
def first_run(col_num, row_num, value): logger.debug("enter first_run") logger_output.debug("enter first_run") workbook, sheet = MyExcel.read_excel(TestConfig.excel_case_path[0], TestConfig.excel_case_path[1]) sheet.cell(column=col_num, row=row_num, value=value) workbook.save(TestConfig.excel_case_path[0])