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
Auf dieser Seite können Sie das Online-Video Create an Excel Data Entry app using Python (Full Tutorial) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Jie Jenn 18 Januar 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 20,257 Mal angesehen und es wurde von 247 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
