【功能自动化】使用Excel文档获取参数数据

环境搭建：

1.需要配置WebTours网站

2.安装pandas

pip install -i https://pypi.tuna.tsinghua.edu.cn/simple numpy
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple pandas
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple python_dateutil
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple pytz
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple  six
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple  xlrd

3.

实现代码

#cases.xls
# skiprows=1 默认跳过第一行# print(data)'''
读取excal文档数据
'''
# 导入包
from selenium  import webdriver
from selenium.webdriver.support.select import Select
from time import sleepimport pandas# 打开浏览器
driver = webdriver.Chrome()
# webdriver.Ie()
# webdriver.Firefox()data = pandas.read_excel('user.xlsx', header=None, names=['yhm','mm','yq'],dtype={'yhm':str,'mm':str,'qy':str})datalist = data.values.tolist()
for x in datalist:yhm = x[0]print(yhm)mm=x[1]print(mm)yq = x[2]print(yq)# 打开网址driver.get("http://127.0.0.1:1080/WebTours/")# 等待3秒sleep(3)# 关闭浏览器# driver.close()#关闭浏览器 及驱动# 切换框架driver.switch_to_default_content()driver.switch_to_frame("body")driver.switch_to_frame("info")driver.find_element_by_link_text("sign up now").click()sleep(3)# 跳转页面，还是需要切换框架driver.switch_to_default_content()driver.switch_to_frame("body")driver.switch_to_frame("info")driver.find_element_by_name("username").send_keys(yhm)driver.find_element_by_name("password").send_keys(mm)driver.find_element_by_name("passwordConfirm").send_keys(mm)driver.find_element_by_name("register").click()sleep(3)# 跳转页面，还是需要切换框架driver.switch_to_default_content()driver.switch_to_frame("body")driver.switch_to_frame("info")expect = yqactual = driver.find_element_by_tag_name("body").textprint(actual)# 精确匹配用in 否则用in if expect in actual:print("pass")else:print("fail")driver.quit()