from selenium import webdrivernfrom selenium.webdriver.common.by import Bynimport os,time,xlwt,xlrdndriver_path = os.path.join(os.path.abspath(__file__),'../../driver/chromedriver.exe')nprint(driver_path)ndriver = webdriver.Chrome(executable_path = driver_path)ndriver.get('http://xx.107.178.xx/zentao/www/index.php?m=user&f=login')ndriver.find_element(By.ID,'account').send_keys('xxx')ndriver.find_element(By.NAME,'password').send_keys('xxxx')ndriver.find_element(By.ID,'submit').click()ncookies = driver.get_cookies()nfor cookie in cookies:n print(cookie)n# 1.写入cookies 到表格中nexcel_path = os.path.join(os.path.abspath(__file__),'../data/zentao_login_cookies.xlsx')n# workbook = xlwt.Workbook(encoding='utf-8')n# worksheet = workbook.add_sheet('cookies')n# for i in range(1,len(cookies)+1):n# worksheet.write(i,0,cookies[i-1]['domain'])n# worksheet.write(i, 1, cookies[i - 1]['name'])n# worksheet.write(i,2, cookies[i - 1]['path'])n# worksheet.write(i, 3, cookies[i - 1]['value'])n# workbook.save(excel_path)nn# 2.读取cookiesnwork_book = xlrd.open_workbook(excel_path)nwork_sheet = work_book.sheet_by_name('cookies')nnfor row_num in range(len(1,work_sheet.nrows)):n cookie_dict = {}n cookie_dict['domain'] = work_sheet.cell_value(row_num,0)n cookie_dict['name'] = work_sheet.cell_value(row_num, 1)n cookie_dict['path'] = work_sheet.cell_value(row_num,2)n cookie_dict['value'] = work_sheet.cell_value(row_num,3)n driver.add_cookie(cookie_dict)nndriver.refresh()ntime.sleep(5)ndriver.quit()n