from seleniumimport webdriver
import xlrd
#登录功能的方法
def login(username,password):
driver = webdriver.Chrome()
driver.get('http://127.0.0.1:5000/')
driver.find_element_by_xpath("//*[text()='登录']").click()
name = driver.find_element_by_xpath('/html/body/form/p[1]/input')
name.send_keys(username)
pwd = driver.find_element_by_xpath('/html/body/form/p[2]/input')
pwd.send_keys(password)
driver.find_element_by_xpath("/html/body/form/p[3]/button").click()
driver.close()
#数据驱动方法
def execute_case(file):
excel = xlrd.open_workbook(file)
sheetdata = excel.sheet_by_index(0)
rownum = sheetdata.nrows
rowlist = []
for xin range(1, rownum):
rowdata = sheetdata.row_values(x)
rowlist.append(rowdata)
login(rowdata[0],rowdata[1])
execute_case('0523.xls')
对应表格数据内容
网友评论