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
En esta página del sitio puede ver el video en línea Create an Excel Data Entry app using Python (Full Tutorial) de Duración hora minuto segunda en buena calidad , que subió el usuario Jie Jenn 18 enero 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 20,257 veces y le gustó 247 a los espectadores. Disfruta viendo!
