python从excel读取用户和密码数据用于自动化登录

#coding=utf-8
from selenium import webdriver
import time
import xlrd


data = xlrd.open_workbook('e:\\test.xlsx')
table = data.sheet_by_name(u'Sheet1')

def account_login():
    bro = webdriver.Firefox()
    bro.get('http://192.168.211.99/naas/account/login.html')
    user_ele = bro.find_element_by_class_name('form-control')
    password_ele = bro.find_element_by_css_selector('input[type="password"]')
    user_ele.send_keys(list[0])
    password_ele.send_keys(list[1])
    time.sleep(1)
    btn = bro.find_element_by_class_name('btn-login').click()
    try:
        bro.find_element_by_class_name('loginTips')
        print('error')
    except:
        print('ok')
    time.sleep(2)
    bro.close()



for i in range(table.nrows):
    list = table.row_values(i)
    account_login()
    print('用户名：%s  密码：%s'%(list[0],list[1]))
    print('*'*20)

转载于:https://www.cnblogs.com/sszhou/p/7851354.html