Python Tkinter Load Excel Data tutorial [openpyxl, tkinter]

Python Tkinter Load Excel Data tutorial [openpyxl, tkinter]

Code First with Hala

1 год назад

18,415 Просмотров

Tkinter Excel Viewer tutorial for beginners. Python GUI project for beginners. Learn how to load and view Excel data with Tkinter. Use a Tkinter Treeview for Excel.

In this tutorial, you will learn how to use Tkinter to view Excel data. In the video you will:
- Create your Python Tkinter application
- Use a Treeview in Tkinter
- Install openpyxl
- Use openpyxl with Python
- Load Excel data in Python
- Display data in the Tkinter Treeview

Source code: https://github.com/codefirstio/tkinter-excel-viewer

Source of Excel file download: https://www.downloadexcelfiles.com/wo_en/download-excel-file-list-countries-world

For more info:
Install and Setup Tkinter for beginners: https://youtu.be/5XdGmhryZBk
Playlist link: https://youtube.com/playlist?list=PLs3IFJPw3G9KL3huzPS7g-0PCbS7Auc7I

Timestamps:
00:00 Introduction and demo
01:05 Project overview
01:39 Installing openpyxl
02:20 Loading excel data in Python
05:00 Creating a Tkinter application
06:30 Adding a Tkinter Treeview

Socials:
My email: [email protected]
Tiktok: https://www.tiktok.com/@hala.codes

*************
**Tags**
Tkinter tutorial
Tkinter install
Tkinter Setup
Tkinter GUI tutorial
GUI tutorial Python
GUI Project Python
Graphical User Interface Python
openpyxl
openpyxl tutorial
learn openpyxl
Ссылки и html тэги не поддерживаются


Комментарии:

alex max
alex max - 13.10.2023 18:19

Привет, сестренка!

Ответить
siddanna arakeri
siddanna arakeri - 26.07.2023 20:24

Only Specific colum and specific row how to see in treeview madam please help me

Ответить
grif5332
grif5332 - 05.05.2023 05:29

great vid. my only issue i had was that it will read the cells with values...but if it has a formula, itll only show the formula. to fix this I added a bit to the openpyxl.load_workbook(path). Here is what I came up with. openpyxl.load_workbook(path, data_only=True)

Ответить
frikuus
frikuus - 03.04.2023 09:46

Great work. Question: how to sort and search by name in columns?

Ответить
Aum Vora
Aum Vora - 27.03.2023 10:37

Thank you soooooo much
I was trying to do this from many days, finally with your video it is now possible

Ответить
C B
C B - 10.03.2023 20:43

I have just completed Python Excel Data Entry with Tkinter Python GUI Project and it is the best 2 videos of this type that I have viewed, and I have viewed a lot! You have explained everything very clearly, at a speed I was comfortable with. A lot of videos are made by Americans who shout fast information and jump about on screen and I just can't follow them.
I only decided to learn Python in January 2023 and I got nowhere really. I understand the language but methodology was just eluding me. You have taught me what I need to know to create an Excel Worksheet in just 2 days! I will now go on to create a complete workbook to replace the app I previously created using Visual Basic. Yes, I am a very old man and you have made me very happy. Thank You.

Ответить
Samuel Jajuan
Samuel Jajuan - 19.01.2023 21:51

how can I do this the other way around? Say i read an nfc card that has a name, age, and absent/present options,I then would like to place that info in a spreadsheet

Ответить
faa'iido diineed
faa'iido diineed - 22.12.2022 03:06

Please can you make a video about converting multiple tkinter files + mysql database into .EXE file without any problems.

Thank you

Ответить
faa'iido diineed
faa'iido diineed - 22.12.2022 03:05

I am proud of you, you helped me a lot thank you.

Ответить
Yūjin-A
Yūjin-A - 18.12.2022 19:06

how can i sole problem of window freezing of pyqt5 gui after connecting it with source code

Ответить
Day to Day local
Day to Day local - 06.12.2022 05:00

Please your picture or video mode

Ответить
Angelo Vener Baloloy
Angelo Vener Baloloy - 31.10.2022 15:21

how can i only choose a number of headings to be display on my treeview ?

Ответить
Jager
Jager - 25.10.2022 09:56

Is there a way to connect a treeview to firebase? I’m doing a project where a user would be able to input data into treeview on the GUI then can access it through the webapp. Your videos have been really helpful especially the firebase and tkinter stuff. Thank you!

Ответить