openpyxl使用

# 安装 pip install openpyxl

#创建excel文件
# from openpyxl import Workbook  #导入
# wb= Workbook() #实例化
# ws= wb.active  #定位到工作表，索引从0开始，默认第一个
# ws1 = wb.create_sheet("Mysheet") # 插入到最后 (默认)
# ws2 = wb.create_sheet("Mysheet", 0) # 插入到最前
# ws3 = wb.create_sheet("Mysheet", -1) # 插入到倒数第二
# ws.title = "New Title"  #修改工作表名
# ws4 = wb["New Title"] #选择工作表"New Title"
# wb.save('balances.xlsx') #保存文件

#例：
# from openpyxl import Workbook
# wb=Workbook()
# ws=wb.active
# for i in range(1,10):    #行列索引从1开始
#     for j in range(1,5):
#         ws.cell(row=i,column=j,value=10)
# wb.save('test.xlsx')

#读取excel文件
# from openpyxl import load_workbook
# wb=load_workbook('test.xlsx')
# ws=wb['Sheet']
# rows=len(tuple(ws.rows))  #获取行数
# cols=len(tuple(ws.columns)) #获取列数
# for i in range(1,rows+1):
#     for j in range(1,cols+1):
#         print(ws.cell(row=i,column=j).value)

#例:
# def test_read_excel(filepath,sheetname):
#     from openpyxl import load_workbook
#     wb=load_workbook(filepath)
#     ws=wb[sheetname]
#     test_data=[]
#     for i in range(1,len(tuple(ws.rows))+1):
#         testcase_data=[]
#         for j in range(1,len(tuple(ws.columns))+1):
#             testcase_data.append(ws.cell(row=i,column=j).value)
#         test_data.append(testcase_data)
#     return test_data
# 
# print(test_read_excel('test.xlsx','Sheet'))

#例：csdn使用cookie登录
from selenium import webdriver
import time,os
from openpyxl import Workbook
from openpyxl import load_workbook

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

# time.sleep(60)

# wb= Workbook()
# ws= wb.active
# ws.title="cookie"
# ws['A1']='name'
# ws['B1']='value'
# ws['C1']='domain'
# ws['D1']='path'
# cookie=driver.get_cookies()
# for i in range(1,len(cookie)+1):
#     ws.cell(row=i + 1, column=1, value=cookie[i - 1]['name'])
#     ws.cell(row=i + 1, column=2, value=cookie[i - 1]['value'])
#     ws.cell(row=i + 1, column=3, value=cookie[i - 1]['domain'])
#     ws.cell(row=i + 1, column=4, value=cookie[i - 1]['path'])
# wb.save('csdn_cookie.xlsx')

wb=load_workbook('csdn_cookie.xlsx')
ws=wb['cookie']
for i in range(2,len(tuple(ws.rows))+1):
       cookie_dict = {}
       cookie_dict['name'] = ws.cell(row=i, column=1).value
       cookie_dict['value'] = ws.cell(row=i, column=2).value
       cookie_dict['domain'] = ws.cell(row=i, column=3).value
       cookie_dict['path'] = ws.cell(row=i, column=4).value
       print(cookie_dict)
       driver.add_cookie(cookie_dict)

time.sleep(5)
driver.refresh()

一个坑：