#-*- coding: utf-8 -*- import xlrd import json def get_excel_data(sheetName,caseName): #存放请求体、响应体 reslist = [] #文件路径 excelDir = '../data/Delivery_System_excel-V1.5.xls' #将表格加载到内存并保持原格式 workBook = xlrd.open_workbook(excelDir,formatting_info=True) #获取对应得sheet workSheet = workBook.sheet_by_name(sheetName) idx = 0 #获取第一列内容(获取用例数) for one in workSheet.col_values(0): if caseName in one: #获取请求体 reqBodyData = workSheet.cell(idx,9).value #获取响应体 respData = workSheet.cell(idx,11).value reslist.append((json.loads(reqBodyData),json.loads(respData))) idx +=1 return reslist
Python 获取表格里的用例参数
最新推荐文章于 2024-06-10 22:18:41 发布