Create an Excel Data Entry app using Python (Full Tutorial)

In this tutorial, we will learn how to create a Microsoft Excel data entry form to simplify Excel data entry using Python. To build this Python app, we will be using PyQt5 library to build the GUI and win32com (also known as pywin32) to interact with Excel spreadsheet.

Buy Me a Coffee? Your support is much appreciated!
----------------------------------------------------------------------------------------------------------------
PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn

Source Code (available to Patreons only):
https://www.patreon.com/posts/create-...

Why use win32com instead of other Excel Pyhon libraries to interact with Excel?
- Interactive. Since you can directly reference the Excel application, any action you perform with Python will directly show up in Excel.
- Can access every single Excel object model vs other Python library are just wrapper with limited objects access.

To download MileIQ template:
https://templates.office.com/en-us/mi...


Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
Patreon: Patreon: JieJenn
By shopping on Amazon → https://amzn.to/2JkGeMD
More tutorial videos on my website → https://LearnDataAnalysis.org
Follow Me on Facebook → Facebook: Learn-Data-Analysis-101284561779059
Business Inquiring: [email protected]

Tags:
#Python #Tutorial #AppDevelopment #Excel