获取skipcase
testcase_path=r'./testcase.xlsx' def skipcase(testcase_path): l=[] wb=load_workbook(testcase_path) ws=wb.get_sheet_by_name(u'接口测试用例') count_row= ws.max_row print count_row for i in range(2,count_row+1): cellvalue=ws.cell(row=i,column=13).value if cellvalue=='False': testcasename=ws.cell(row=i,column=1).value l.append(testcasename) return l