excel单元测试---步骤1：编写测试方法

import requests

class HttpRequest:
    """requests请求需要转入的参数"""

    def http_request(self,method, url, data,auth = None,headers =None ):
        ‘‘‘url:请求地址 http://xxxx:port
           param:传递的参数 非必填参数 字典的格式传递参数
           method:请求方式  支持get,post,put...
           get:获取信息，post:添加信息，put:修改更新信息
        ‘‘‘
        if method.lower() in (‘get‘,‘post‘,‘put‘,‘patch‘):
            if method.lower() == ‘get‘:
                res = requests.get(url, data, auth = auth, headers= headers)
            elif method.lower() == ‘post‘:
                res = requests.post(url, data, headers = headers)
            elif method.lower() == ‘put‘:
                res = requests.put(url, data, headers = headers)
            else:
                res = requests.patch(url, data, headers = headers)

            return res
        else:
            raise Exception(‘暂不支持的请求方式‘)