数据驱动登录验证python+selenium

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')

对应表格数据内容