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: / jiejenn
By shopping on Amazon → https://amzn.to/2JkGeMD
More tutorial videos on my website → https://LearnDataAnalysis.org
Follow Me on Facebook → / learn-data-analysis-101284561779059
Business Inquiring: YouTube@LearnDataAnalysis.org
Tags:
#Python #Tutorial #AppDevelopment #Excel
On this page of the site you can watch the video online Create an Excel Data Entry app using Python (Full Tutorial) with a duration of hours minute second in good quality, which was uploaded by the user Jie Jenn 18 January 2021, share the link with friends and acquaintances, this video has already been watched 20,257 times on youtube and it was liked by 247 viewers. Enjoy your viewing!
