python自动登录网站导出excel_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)