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])
