【python】跳过验证直接登陆-把cookie导入excl表格然后调用

概述importtimeimportxlwtimportxlrdfromcommon.comfigimportlocal_configfromseleniumimportwebdriverfromwebdriver_manager.chromeimportChromeDriverManagerdriver=webdriver.Chrome(ChromeDriverManager().install())driver.implicitly_wait(10)driver.get(loc

import time
import xlwt
import xlrd
from common.comfig import local_config
from selenium import webdriver
from webdriver_manager.Chrome import ChromeDriverManager

driver = webdriver.Chrome(ChromeDriverManager().install())
driver.implicitly_wait(10)
driver.get(local_config.URL)
#写入表格，第一次运行后注释掉
# time.sleep(30)
# workbook=xlwt.Workbook(enCoding='utf-8')
# worksheet=workbook.add_sheet('sheet1')
# worksheet.write(0,0,'name')
# worksheet.write(0,1,'value')
# worksheet.write(0,2,'domain')
# worksheet.write(0,3,'path')
# i=1
# for cookie in driver.get_cookies():
#     worksheet.write(i,0,cookie['name'])
#     worksheet.write(i,1,cookie['value'])
#     worksheet.write(i,2,cookie['domain'])
#     worksheet.write(i,3,cookie['path'])
#     i=i+1
# workbook.save('cookie.xlsx')
#调用写入表格的cookie
wb=xlrd.open_workbook('cookie.xlsx')
sheel=wb.sheet_by_name('sheet1')
for row in range(1,sheel.nrows):
    driver.add_cookie({'name':sheel.cell_value(row,0),'value':sheel.cell_value(row,1),'domain':sheel.cell_value(row,2),'path':sheel.cell_value(row,3)})
driver.refresh()

总结

以上是内存溢出为你收集整理的【python】跳过验证直接登陆-把cookie导入excl表格然后调用全部内容，希望文章能够帮你解决【python】跳过验证直接登陆-把cookie导入excl表格然后调用所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。