Assign Excel cell value from Datepicker widget Selection using Python

narenchunduri at gmail.com narenchunduri at gmail.com
Sun Jun 28 11:04:04 EDT 2020


When I run the python code I should be able to open my Excel and when I click on one Excel cell I should have my datepicker widget popped up and I should be able to select any date from my datepicker widget as my Excel cell value

Tried below code but in vain: (Used jupyter Notebook)

from ipywidgets import widgets
from openpyxl import *

wb = load_workbook('My_Excel.xlsx')
worksheet = wb.active
worksheet['B1'] = 'Datepicker'
worksheet['B2'] = widgets.DatePicker()
wb.save('My_Excel.xlsx')
wb.close()
Error Occured: ValueError: Cannot convert DatePicker(value=None) to Excel


More information about the Python-list mailing list