Python Forum
Date entry in box format issue
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Date entry in box format issue
#7
It seems to work now but it gives me back this error when I try to write it in excel
Exception in Tkinter callback
Traceback (most recent call last):
  File "C:\Program Files (x86)\Python38-32\lib\tkinter\__init__.py", line 1883, in __call__
    return self.func(*args)
  File "C:/Users/pc/Desktop/file/project.py", line 196, in insert
    sheet.cell(row=current_row + 1, column=8).value = self.bday_entry.get()
  File "C:\Program Files (x86)\Python38-32\lib\site-packages\openpyxl\cell\cell.py", line 216, in value
    self._bind_value(value)
  File "C:\Program Files (x86)\Python38-32\lib\site-packages\openpyxl\cell\cell.py", line 199, in _bind_value
    raise ValueError("Cannot convert {0!r} to Excel".format(value))
ValueError: Cannot convert {'day': 11, 'month': 11, 'year': 1999} to Excel
I've tried datetime.strptime to convert the date but with no luck.
Reply


Messages In This Thread
Date entry in box format issue - by PeroPuri - Apr-18-2020, 08:03 PM
RE: Date entry in box format issue - by joe_momma - Apr-18-2020, 09:56 PM
RE: Date entry in box format issue - by PeroPuri - Apr-19-2020, 11:26 AM
RE: Date entry in box format issue - by joe_momma - Apr-19-2020, 04:10 PM
RE: Date entry in box format issue - by PeroPuri - Apr-20-2020, 10:24 PM
RE: Date entry in box format issue - by joe_momma - Apr-21-2020, 02:26 AM
RE: Date entry in box format issue - by PeroPuri - Apr-25-2020, 11:03 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Entry Widget issue PA3040 16 7,235 Jan-20-2021, 02:21 PM
Last Post: pitterbrayn
  Transfer Toplevel window entry to root window entry with TKinter HBH 0 4,561 Jan-23-2020, 09:00 PM
Last Post: HBH
  [Tkinter] how to get the entry information using Entry.get() ? SamyPyth 2 3,582 Mar-18-2019, 05:36 PM
Last Post: woooee

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020