def test_node_api(self): url = "https://www.v2ex.com/api/nodes/show.json" #querystring = {"name":"php"} a = read_excel("xx.xlsx", 0, 0) for node_name in a: #for node_name in ['php',"python","qna"]: response = requests.request("GET", url, params={ "name": node_name }).json() self.assertEqual(response['name'], node_name) print(response)
import unittest import HTMLTestReportCN import time from funct import read_excel from logom import jietu import HTMLTestReportCN import time import unittest from car import car_main, car2, car3, car4, car5,car6 username=read_excel("h.xlsx",0,0) card=read_excel("h.xlsx",1,0) class add(unittest.TestCase): def setUp(self): print("测试开始") def test_01(self): self.assertEqual(car_main(),"首页") jietu("狗蛋121.png") print("首页判断")
import xlrd from funct import read_excel import xlwt print(read_excel(r'mycord.xlsx', 0, 0)) print(read_excel(r'mycord.xlsx', 1, 0))