In this tutorial we are going to create a simple date picker tool for your Excel spreadsheet in Python.

This is the first tutorial I go into Excel and PyQt5 integration. Before go into the development, I want to touch on few things such as what are the advantages and disadvantages using PyQt5 Calender widget in Excel.

Buy Me a Coffee? Your support is much appreciated!
PayPal Me:
Venmo: @Jie-Jenn

Full Script:

import sys, os
from PyQt5.QtWidgets import QApplication, QWidget, QCalendarWidget
import win32com.client as win32

xlApp = win32.Dispatch('Excel.Application')
xlApp.visible = True

class CalendarApp(QCalendarWidget):
    def __init__(self):

    def insert_date(self, date):
        # return store_value(date)
            xlApp.Selection.value = date.toPyDate().strftime('%m-%d-%Y')
        except Exception as e:

app = QApplication(sys.argv)
cal = CalendarApp()