如何从“Excel”中读取“Date”(日日期MMM )值，并使用“Selenium WebDriver”将该值发送到“Date picker”中以进行自定义日历

from selenium import webdriver
from selenium.webdriver.common.keys import Keys
import openpyxl

driver = webdriver.Chrome()

workbook = openpyxl.load_workbook('文件路径/文件名.xlsx')
sheet = workbook['工作表名']

date_value = sheet['A1'].value

driver.get('目标网页的URL')

date_picker = driver.find_element_by_xpath('Date picker元素的XPath')
date_picker.click()

date_picker.clear()

date_picker.send_keys(date_value)

date_picker.send_keys(Keys.RETURN)

driver.quit()