Just wanted to say that I've been watching all your videos a lot. You're an outstanding teacher, and you make understanding code extremely easy compared to others. It's a shame you haven't uploaded more videos in a year, because you're truly a hidden gem.
These tutorials are great for learning the Tkinter library I hope everyone is jumping back and forth between the video, their code and the docs to see the full capabilities of Tk
Thank you for this tutorial. Your explanations are very clear. I can follow along without getting lost. Now I understand better how to build Python code with tkinter. Thank you, Hala!
Very well structured tutorial! No BS, direct to the point! I'm new at Python but already made some progs using ttk so, knew most of the things you explained! Nevertheless, you gave me a new insight on how to structure the widgets around the root>frame>cols structure/hierarchy... I was making it to complex... but you don't! ;) Keep on doing great stuff like this! Congrats!
hello Hala ,thanks a lot for the superb explanation , i found that when i click on mode button many times the tree frame expands and i solved this issue like this : in the four treeview columns add this code : stretch=False ....and if you like to make the heading and data be in the center add this code with previous code like this: anchor='center' ,, 🙂👍
I had the same issue, I solved it with cols=("Name","Age","Subscription","Employment") treeview=ttk.Treeview(treeFrame,show="headings", yscrollcommand=treeScroll.set,columns=cols,height=13) treeview.column("Name", width=100, anchor='w', minwidth=100, stretch=tk.NO) treeview.column("Age", width=50, anchor="center", minwidth=50, stretch=tk.NO) treeview.column("Subscription", width=100, anchor="w", minwidth=100, stretch=tk.NO) treeview.column("Employment", width=100, anchor="w", minwidth=100, stretch=tk.NO) for col in cols: treeview.heading(col,text=col,anchor='center') treeview.pack() treeScroll.config(command=treeview.yview) I hope had helping you
you should try it... I started one year ago and now do so many things with python! there are libraries for all tastes... and with great TH-cam tutorials like these, online free courses (Harvard CS50 are GREAT!)... and chatGPT... you have it all to learn by yourself! ;)
I've enjoyed it very much , thank you very much The way you explained the code and what it is used for was helpful , i believe it is a good lesson for me and all other youtubers . keep this good work , may Allah (God) bless you and your work
Thank you very much. I have the perfect background to follow your explanation and be not bored fram the explanation. For a absolut beginner is it too fast. So many concepts in one video. Gui, function, context, More pls 😊 thx
hy, where are you, why you don't complete your python series, your job is perfect, great explanation , I hope you continue these series thank you so match
Excelent video! Excelent explanation. You are a very good teacher! Congratulations. Sugestion: make a video, like that usin Firebase Realtime Database (if as possible with Authentication too). I have a very symilar script in Python with Firebase, but I`m using Flet to make the Python GUI
Hi Hala, thanks for cool things. Hoping next time you creat a python app that we can insert datas from app and store them in sql and we can use it later for extracting to excel report 🙏🙏🙏
Is their a way to make it auto update every few mins? I have made this into a .exe file from watching your video about using pyinstaller. I have modified it to where I can use it at my work because I uploaded it to our network and others can just open it from a shared network and leave it open but it will not update unless they close out the application and reopen it. But it does work with multiple users having the GUI open but no refresh. I am the only one with user rights to edit the excel spreadsheet, so that is a good thing if I need to delete something. I appreciate all your work you do in these videos they help a lot for a beginner like myself.
Great Video and project, I am working currently in something similar but my DB is quite big so I ma using parquet file, does parquet will work like excel worked in this project?
That is great, what I need , is the possibility to update a row( or multiple rows) directly from the python app and with a button update the Excel file. Is this even possible?
Amazing content! Thank you for everything. I was wondering, is it possible to add a browse button where the end user can browse their local machine and choose the excel file that they want to load?
Would you be able to put in a working search bar? If so, how? Also instead of making the the columns pre-made how would you make it to change depending on what excel spreadsheet is uploaded? I'm trying to make a GUI like this that someone can just insert or import their excel file and the Treeview would just use whatever column names were used in the spreadsheet.
great video Hala, I am working on multi window app for inventory system depend on locations and date it would be so helpful if you make a tutorial about that many thanks
If you are getting the error: root.tk.call("source", "forest-light.tcl") _tkinter.TclError: no files matched glob pattern "*.png" Then please make sure that you have also imported the folder forest-dark and forest-light from the original rest-ttk-theme repo. Didn't realise Hala version did not have those files. So make sure that the folders are in the same directory as the place where you have cloned Hala's repo.
what if i have columns in my excel sheet which needs calculations. For instance, I have a dataset and it has a feature called fuel cost which has to be calculated by taking the product of litres and rate per litre. How do i incorporate this feature of calculating the value and then also updating it in the excel sheet in this code?
Thank you so much for this video. I have a problem with coding this, when I use insert it doesn't work as a placeholder, it literally adds the text to the entry. Any suggestions? Please help me 🙏🏻♥️
That's GREAT!. but I found one bug on your code. when I toggle the checkbox to change the theme the treeview will expand. I tried to fix it using row and column configure but I can't. how can I fix it?
Getting Error @ the following step: root.tk.call("source", "Forest-light.tcl"). Error received: Exception has occurred: TclError no files matched glob pattern "*.png" File "C:\Users.......Employee Info.py", line 7, in root.tk.call("source", "Forest-light.tcl") _tkinter.TclError: no files matched glob pattern "*.png"
I am new to programming , how to rectify this kind of error "Exception has occurred: TclError no files matched glob pattern "*.png" File "D:\software\main.py", line 59, in root.tk.call("source", "forest-light.tcl") _tkinter.TclError: no files matched glob pattern "*.png"" ?
![Python Dashboard with Tkinter and Matplotlib tutorial [for beginners]](http://i.ytimg.com/vi/2JjQIh-sgHU/mqdefault.jpg)
![Python Dashboard with Tkinter and Matplotlib tutorial [for beginners]](/img/tr.png)
![[#2024MAMA] BIGBANG (빅뱅) - 뱅뱅뱅 (BANG BANG BANG) + FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/EQsYfiPR9uM/mqdefault.jpg)
The way she explains the code and what it is used for as she goes along is a lesson other youtubers could learn.
Just wanted to say that I've been watching all your videos a lot. You're an outstanding teacher, and you make understanding code extremely easy compared to others.
It's a shame you haven't uploaded more videos in a year, because you're truly a hidden gem.
These tutorials are great for learning the Tkinter library I hope everyone is jumping back and forth between the video, their code and the docs to see the full capabilities of Tk
the best explication in the world
I haven't even finished the video, but you teach very well, I'm Brazilian
Thank you for this tutorial. Your explanations are very clear. I can follow along without getting lost. Now I understand better how to build Python code with tkinter. Thank you, Hala!
Very well structured tutorial! No BS, direct to the point!
I'm new at Python but already made some progs using ttk so, knew most of the things you explained! Nevertheless, you gave me a new insight on how to structure the widgets around the root>frame>cols structure/hierarchy... I was making it to complex... but you don't! ;)
Keep on doing great stuff like this! Congrats!
I've watched three of your videos now. Thank you and well done.
Excellent presentation about developing a fairly simple app to interface with Excel. Thank you for sharing.
You got a new subscriber. First time looking at Python.
you are amazing, this is exactly what I needed from start to finish!
Thank you very much, I had a few points that I did not understand but with this video I now understand them.
I seldom comment on tutorial videos, but this one is good. Keep it up!
excellent presentation and very clear mind
That was an excellent presentation with a good pace which made it easy to follow along.
hello Hala ,thanks a lot for the superb explanation , i found that when i click on mode button many times the tree frame expands and i solved this issue like this : in the four treeview columns add this code : stretch=False ....and if you like to make the heading and data be in the center add this code with previous code like this: anchor='center' ,, 🙂👍
I had the same issue, I solved it with
cols=("Name","Age","Subscription","Employment")
treeview=ttk.Treeview(treeFrame,show="headings",
yscrollcommand=treeScroll.set,columns=cols,height=13)
treeview.column("Name", width=100, anchor='w', minwidth=100, stretch=tk.NO)
treeview.column("Age", width=50, anchor="center", minwidth=50, stretch=tk.NO)
treeview.column("Subscription", width=100, anchor="w", minwidth=100, stretch=tk.NO)
treeview.column("Employment", width=100, anchor="w", minwidth=100, stretch=tk.NO)
for col in cols:
treeview.heading(col,text=col,anchor='center')
treeview.pack()
treeScroll.config(command=treeview.yview)
I hope had helping you
I don't know Python but what are you showing is awesome, keep moving!!!!!!!!
you should try it... I started one year ago and now do so many things with python!
there are libraries for all tastes... and with great TH-cam tutorials like these, online free courses (Harvard CS50 are GREAT!)... and chatGPT... you have it all to learn by yourself! ;)
Amazing Video with all necesarry explanation. The best I ever saw
Excellent video and all well explained getting straight to the point. Brilliant thank you x
I've enjoyed it very much , thank you very much
The way you explained the code and what it is used for was helpful , i believe it is a good lesson for me and all other youtubers .
keep this good work , may Allah (God) bless you and your work
Great course. Thank you so much. I hope to see your more and more lightweight widget software.
Best wishes to you.
Thank you so much for your tutorial… lots of love ❤from India
Thank you very much. I have the perfect background to follow your explanation and be not bored fram the explanation. For a absolut beginner is it too fast. So many concepts in one video. Gui, function, context,
More pls 😊 thx
Sry for my horrifying grammar
hy, where are you, why you don't complete your python series, your job is perfect, great explanation , I hope you continue these series thank you so match
thank youuu, I have to do python project and your video help me a lot
Nice video, it took me a while to place the required images but I figured it out.
Excelent video! Excelent explanation. You are a very good teacher! Congratulations. Sugestion: make a video, like that usin Firebase Realtime Database (if as possible with Authentication too). I have a very symilar script in Python with Firebase, but I`m using Flet to make the Python GUI
Great video Hala! keep it up
Hala, thanks for the great video. You are a very good teacher. Well explained 👏🏻👏🏻
I like all your videos; You're a great teacher!!thank's
Great video! Can you in the future make a video about classes in Python?
Hi Matias, sure thing :) Coming soon!
Very well explained. Thank you!
god that tkinter ui looks so much better than mine
gonna need to figure out how to do that
Excellent! thank-you very much Hala!😍
Dope stuff!
Legit tutorial
Hi Hala, thanks for cool things. Hoping next time you creat a python app that we can insert datas from app and store them in sql and we can use it later for extracting to excel report 🙏🙏🙏
What a great explanation! Thank you so much❤.
ОГОНЬ!!! БОМБА!!! СУПЕР!!!
Firstly, thank you for your tutorails. I would like to ask what font do you use?
Is their a way to make it auto update every few mins? I have made this into a .exe file from watching your video about using pyinstaller. I have modified it to where I can use it at my work because I uploaded it to our network and others can just open it from a shared network and leave it open but it will not update unless they close out the application and reopen it. But it does work with multiple users having the GUI open but no refresh. I am the only one with user rights to edit the excel spreadsheet, so that is a good thing if I need to delete something. I appreciate all your work you do in these videos they help a lot for a beginner like myself.
Just looking at the comments I subscribed and shared the video for future use
Great Video and project, I am working currently in something similar but my DB is quite big so I ma using parquet file, does parquet will work like excel worked in this project?
All I can say is thank you
Excellent tutorial!
Go Hala, go Hala, it is wonderful and amazing seeing more women coding. Thank you
She is super amazing.
That is great, what I need , is the possibility to update a row( or multiple rows) directly from the python app and with a button update the Excel file. Is this even possible?
Thank you for the interesting explanation
Amazing content! Thank you for everything. I was wondering, is it possible to add a browse button where the end user can browse their local machine and choose the excel file that they want to load?
Thanks sister you give me best idea your realy thanks
@Code First with Hala, nice video, please say: how to edit and values at the treeview??? thank you
AWSOME VIDEO TY
Thank you for an excellent video. New to your channel and just subscribed!
Thank you for this completely tutorial
Very presentable; one question though, can we use something like googlesheet or synchronize the excell with some sort of cloud database?
Btw thanks
Thank you so much for sharing this video ❤
Can you do a vidéo about filtering those data ? Or maybe loading theme from oracle database pliz
AMazinglyexplaied. Thank you!!
Would you be able to put in a working search bar? If so, how? Also instead of making the the columns pre-made how would you make it to change depending on what excel spreadsheet is uploaded? I'm trying to make a GUI like this that someone can just insert or import their excel file and the Treeview would just use whatever column names were used in the spreadsheet.
So informative video.
I was wondering how to change the value in the GUI from Employed to Unemployed as the checkbox is toggled. Do you have a video about that?
Where can I find a prof as smart as you 👏🏽
Thank YOU and chokran HALA
Nice, thank you!
شكرا لك 🙂👍🌷 .. Thank you hala ❤
great video Hala, I am working on multi window app for inventory system depend on locations and date it would be so helpful if you make a tutorial about that many thanks
💕💕💕💕 very helpful ❤️❤️❤️❤️
Glad it was helpful! Thanks for the support :)
If you are getting the error:
root.tk.call("source", "forest-light.tcl")
_tkinter.TclError: no files matched glob pattern "*.png"
Then please make sure that you have also imported the folder forest-dark and forest-light from the original rest-ttk-theme repo. Didn't realise Hala version did not have those files.
So make sure that the folders are in the same directory as the place where you have cloned Hala's repo.
Getting the same error when the folder is in the same directory, Any suggestions?
Same error
Really Interesting
Thank you very much!
Super 👍
what if i have columns in my excel sheet which needs calculations. For instance, I have a dataset and it has a feature called fuel cost which has to be calculated by taking the product of litres and rate per litre. How do i incorporate this feature of calculating the value and then also updating it in the excel sheet in this code?
please how to get the git folder ????
Thank you so much for this video.
I have a problem with coding this, when I use insert it doesn't work as a placeholder, it literally adds the text to the entry. Any suggestions? Please help me 🙏🏻♥️
Super Like!
Hy!
I downloaded the code and when I switch between dark and light mode the window always gets wider. Why is this?
Nice project
Can you make a web app for food order system in python
Cool video, learned a lot from it ❤❤❤
...nice.thank you
What about long text in tkinter, want to wrap it but don't have adjustable row height
That's GREAT!. but I found one bug on your code. when I toggle the checkbox to change the theme the treeview will expand. I tried to fix it using row and column configure but I can't. how can I fix it?
Please do this in custom tkinter library. Thank you.
Nice!
Could you please upload a video to connect splash screen with another dialog for qt designer pyqt5
when switching themes repeatedly, the window size stretches to the right
Yeah, I noticed that too.
how to dynamically resize the rows based on the lines each excel row?
Getting Error @ the following step: root.tk.call("source", "Forest-light.tcl"). Error received: Exception has occurred: TclError
no files matched glob pattern "*.png"
File "C:\Users.......Employee Info.py", line 7, in
root.tk.call("source", "Forest-light.tcl")
_tkinter.TclError: no files matched glob pattern "*.png"
did u solve this? im having the same issue
Great job 👏👏, I tried to use you code to learn some python features but I got an error, can you help me to do solve it
What about if you delete information from the excel sheet and run again? i just receive "None" where I deleted information. How can this be fixed ?
When I use openpyxl multiple times it slows down my excel sheet massively. Why is that?
Is because you don't kill fully the process.
I love you so much ❤
How did you import the excel file like what appears in the left side bar in Pycharm?
is there a way to resize the switch button? I don't know why, but it looks super small on my screen
I am new to programming , how to rectify this kind of error
"Exception has occurred: TclError
no files matched glob pattern "*.png"
File "D:\software\main.py", line 59, in
root.tk.call("source", "forest-light.tcl")
_tkinter.TclError: no files matched glob pattern "*.png"" ?
list_values = list(sheet.values). my problem is Cannot access member "values" for type "_WorkbookChild". How can i solve this
When I run it on pydroid the second widget is crowded and overlayed.
Can you please give solution to people use only pydroid
nice
How would you go about creating a button to delete the last entry
I have an excel file with highlighted cells can I view it on tkinter gui
hi how did u get the treeview theme ? is there a style cript or something ?