xlrd与xlwt模块

#安装  pip install xlrd   pip install xlwt

#写入文件
import xlwt

# workbook=xlwt.Workbook(encoding='utf-8')
# sheet=workbook.add_sheet('Sheet1')
# sheet.write(0,0,'hello')
# sheet.write(0,1,'world')
# sheet.write(1,0,'python')
# sheet.write(1,1,'study')
# workbook.save('test1.xlsx')

#读取文件
# import xlrd
# workbook=xlrd.open_workbook('test1.xlsx')
# sheet=workbook.sheet_by_name('Sheet1')
# for i in range(sheet.nrows):
#     for j in range(sheet.ncols):
#         print(sheet.cell_value(i,j))

#例：cookie登录
from selenium import webdriver
import time,os
import xlwt,xlrd

path=os.path.join(os.path.dirname(__file__),'..','webdriver','chromedriver')
driver=webdriver.Chrome(executable_path=path)
driver.get('https://www.lagou.com/')
driver.maximize_window()


# time.sleep(40)
#
# workbook=xlwt.Workbook(encoding='utf-8')
# sheet=workbook.add_sheet('Sheet1')
# sheet.write(0,0,'name')
# sheet.write(0,1,'value')
# sheet.write(0,2,'domain')
# sheet.write(0,3,'path')
#
# cookie=driver.get_cookies()
#
# for i in range(1,len(cookie)+1):
#     sheet.write(i, 0, cookie[i - 1]['name'])
#     sheet.write(i, 1, cookie[i - 1]['value'])
#     sheet.write(i, 2, cookie[i - 1]['domain'])
#     sheet.write(i, 3, cookie[i - 1]['path'])
#
# workbook.save('./lagou_cookie.xlsx')

workbook=xlrd.open_workbook('./lagou_cookie.xlsx')
sheet=workbook.sheet_by_name('Sheet1')
for i in range(1,sheet.nrows):
    cookie_dict={}
    cookie_dict['name'] = sheet.cell_value(i, 0)
    cookie_dict['value'] = sheet.cell_value(i, 1)
    cookie_dict['domain'] = sheet.cell_value(i, 2)
    cookie_dict['path'] = sheet.cell_value(i, 3)
    driver.add_cookie(cookie_dict)

time.sleep(5)
driver.refresh()