如何用python selenium在excel电子表格中插入信息

from selenium import webdriver
from openpyxl import load_workbook

driver = webdriver.Chrome()

workbook = load_workbook('path/to/excel/file.xlsx')

worksheet = workbook.active

cell = worksheet['A1']  # 选择要插入信息的单元格
cell.value = 'Hello, World!'  # 插入信息

workbook.save('path/to/excel/file.xlsx')
workbook.close()

from selenium import webdriver
from openpyxl import load_workbook

# 创建WebDriver对象
driver = webdriver.Chrome()

# 打开Excel文件
workbook = load_workbook('path/to/excel/file.xlsx')

# 选择工作表
worksheet = workbook.active

# 插入信息
cell = worksheet['A1']
cell.value = 'Hello, World!'

# 保存并关闭Excel文件
workbook.save('path/to/excel/file.xlsx')
workbook.close()

# 关闭WebDriver
driver.quit()