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