No video :(

Python Tkinter Load Excel Data tutorial [openpyxl, tkinter]

Подписаться 37 тыс.

Просмотров 19 тыс.

50% 1

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: github.com/cod...
Source of Excel file download: www.downloadex...
For more info:
Install and Setup Tkinter for beginners: • Install and Setup Tkin...
Playlist link: • Tkinter tutorials
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: code.first.io@gmail.com
Tiktok: / 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

Опубликовано:

15 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@colinbolton2052 Год назад

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.

@aumvora7844 Год назад

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

@faaiidodiineed6924 Год назад

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

@NOUANIAHMED 2 месяца назад

thanx

@frikuus Год назад

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

@grif5332 Год назад

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)

@samueljajuan9366 Год назад

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

@yujin-a5927 Год назад

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

@angelovenerbaloloy8243 Год назад

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

@faaiidodiineed6924 Год назад

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

@Albrazi Год назад

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!

@Albrazi Год назад

Never mind. I rewatched your other video about firebase CRUD and it was a little tricky to implement it using a treeview but it worked (at least for creating and reading so far)