[email protected](“item“, readExcel()) 测试用例参数化，参数从Excel中读取，实现执行不同数据

项目需要将请求数据储存在Excel中，用例执行的时候再读取请求的数据。另外，需要将登录接口获取的{"token": ""}     添加到后续接口请求固定的params中。

import requests
import xlrd
import pytest

def token():
    response = requests.request(method='POST', url='', params=None, json=None, headers={"Content-Type":"text/plain"})
    r = response.json()
    response_token = r['data']['access_token']
    return response_token

def readExcel():
    book = xlrd.open_workbook(r'E:\pythondemo\first-excel.xls')
    sheet = book.sheet_by_index(0)
    # 循环读取每行数据
    return [dict(zip(sheet.row_values(0), sheet.row_values(row))) for row in range(2, sheet.nrows)]

class Test:
    def requests(self, request_data):
        token_value = token()
        dict_token = {"token": token_value}
        params_token = eval(request_data['params'])
        params_token.update(dict_tok