简单的接口自动化脚本

import requests
# noinspection PyUnresolvedReferences
import json
# noinspection PyUnresolvedReferences
import openpyxl
from openpyxl import load_workbook
wb = load_workbook("D:/test/interface.xlsx")
sh = wb["Sheet1"]
row = sh.max_row
column = sh.max_column

for row in  range(2,row+1):
    url = sh.cell(row=row,column=5).value
    data = sh.cell(row=row,column=6).value
    qiwang=sh.cell(row=row ,column=7).value
    data = json.loads(data)
    method = sh.cell(row=row,column=4).value

    if method == "get":
         reponse =requests.get(url,data)
         reponse=reponse.json()
        # print(reponse.text)
    elif method=="post":
        data=json.dumps(data)
        header = {"Content-type": "application/json"}
        reponse=requests.post(url=url,data=data,headers=header)
        reponse=reponse.json()



    try:
        assert eval(qiwang)==reponse
        print(row,"测试通过")
        print("预期结果:",qiwang)

    except:
        print("期望结果:",qiwang)
        print("实际结果:",reponse)
        sh.cell(row=row, column=8).value = "测试不通过"
        wb.save("D:/test/interface.xlsx")
        print(row,"测试不通过")