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
Sur cette page du site, vous pouvez voir la vidéo en ligne Create an Excel Data Entry app using Python (Full Tutorial) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Jie Jenn 18 janvier 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 20,257 fois et il a aimé 247 téléspectateurs. Bon visionnage!
