[Python知识库]Python 获取表格里的用例参数

#-*- 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