Python Excel App - Excel Viewer & Data Entry Form [Tkinter, openpyxl] Python GUI Project

Ғылым және технология

Build a modern Tkinter GUI project to automate Excel tasks with Python. This Python GUI project works as both a data entry form and an Excel viewer.
In this video, you will:
- Create your first Tkinter application
- Create a modern Tkinter app
- Use a Tkinter theme with ttk
- Create a Tkinter data entry form
- Use the Tkinter Button, ComboBox, Spinbox, Entry, CheckButton
- Style and modify Tkinter widgets
- Use both a dark and a light mode for the app
- Install openpyxl
- Load data from Excel into Python
- Use data entry form to add data into Excel
Theme Github repo: github.com/rdbende/Forest-ttk...
Source code repo: github.com/codefirstio/tkinte...
Timestamps:
00:00 Introduction and Overview
01:05 Forest-ttk Theme Overview
01:58 Project folder structure
03:13 Starter code
04:44 Using the theme
05:40 Understanding Tkinter geometry managers
10:16 Creating the Name entry
15:36 Creating the Age spinbox
17:56 Creating the Subscription Status combobox
20:44 Creating the Employment Status checkbutton
22:58 Creating the Insert button
23:34 Updating the padding of the widgets
25:19 Creating the separator
26:15 Creating the Mode switch
27:17 Changing between dark mode and light mode
29:34 Creating the Treeview to display the Excel data
34:21 Installing openpyxl
35:27 Loading data from Excel into the treeview
39:28 Collecting the data from the Insert Row form
42:52 Inserting the data into the Excel sheet and treeview
45:12 Clearing the form after inserting
Socials:
My email: code.first.io@gmail.com
Tiktok: / hala.codes
*************
*Tags*
Tkinter tutorial
Tkinter Data Entry
Data Entry form Tkinter
Tkinter install
Tkinter Setup
Tkinter GUI tutorial
GUI tutorial Python
GUI Project Python
Graphical User Interface Python
Python tutorial
openpyxl
openpyxl tutorial
learn openpyxl

Пікірлер: 130

  • @mthorne074
    @mthorne0748 ай бұрын

    The way she explains the code and what it is used for as she goes along is a lesson other youtubers could learn.

  • @gunloco5207
    @gunloco52074 ай бұрын

    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

  • @shallanrambaran7090
    @shallanrambaran70905 ай бұрын

    After 2 mins of how she tackled the lesson I saved the video because I can tell I'm not going to be wasting my time here. Will try her tutorial in a few days (I will be more free then). I love how Hala starts the video; no nonsense and straight to the point.

  • @blendid242
    @blendid2428 ай бұрын

    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!

  • @juancharlie777
    @juancharlie7774 ай бұрын

    I've watched three of your videos now. Thank you and well done.

  • @johncheung4905
    @johncheung4905 Жыл бұрын

    Very well explained. Thank you!

  • @billpowell5931
    @billpowell5931 Жыл бұрын

    Excellent presentation about developing a fairly simple app to interface with Excel. Thank you for sharing.

  • @carneica
    @carneica3 ай бұрын

    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!

  • @Deepakkumar-iu2ve
    @Deepakkumar-iu2ve Жыл бұрын

    What a great explanation! Thank you so much❤.

  • @marciojunior3021
    @marciojunior3021 Жыл бұрын

    Hala, thanks for the great video. You are a very good teacher. Well explained 👏🏻👏🏻

  • @user-ih7np2uh3f
    @user-ih7np2uh3f5 ай бұрын

    Amazing Video with all necesarry explanation. The best I ever saw

  • @marcdoutrepont392
    @marcdoutrepont3926 ай бұрын

    Excellent! thank-you very much Hala!😍

  • @Steve.Outdoors
    @Steve.Outdoors3 ай бұрын

    Excellent video and all well explained getting straight to the point. Brilliant thank you x

  • @bithepower9081
    @bithepower9081 Жыл бұрын

    Thank you for an excellent video. New to your channel and just subscribed!

  • @painkillerO8
    @painkillerO84 ай бұрын

    You got a new subscriber. First time looking at Python.

  • @gerancemdm3747
    @gerancemdm3747 Жыл бұрын

    I like all your videos; You're a great teacher!!thank's

  • @Rlearning1
    @Rlearning1 Жыл бұрын

    Wonderful! Thanks!

  • @serenadenphoto
    @serenadenphoto2 ай бұрын

    That was an excellent presentation with a good pace which made it easy to follow along.

  • @DexterOhaeri
    @DexterOhaeri3 ай бұрын

    I seldom comment on tutorial videos, but this one is good. Keep it up!

  • @zeli595
    @zeli5956 ай бұрын

    Great course. Thank you so much. I hope to see your more and more lightweight widget software. Best wishes to you.

  • @vasbkamarxil1260
    @vasbkamarxil1260 Жыл бұрын

    ОГОНЬ!!! БОМБА!!! СУПЕР!!!

  • @barackuse
    @barackuse Жыл бұрын

    Nice video, it took me a while to place the required images but I figured it out.

  • @cryptolikeaboss
    @cryptolikeaboss Жыл бұрын

    Dope stuff! Legit tutorial

  • @kanurimani8536
    @kanurimani85369 ай бұрын

    Thank you so much for your tutorial… lots of love ❤from India

  • @learn2apply
    @learn2apply7 ай бұрын

    Great video Hala! keep it up

  • @Funtstk
    @Funtstk8 ай бұрын

    excellent presentation and very clear mind

  • @user-ih7ot7vl8u
    @user-ih7ot7vl8u Жыл бұрын

    Thank you for this completely tutorial

  • @user-ds9ey8pp5h
    @user-ds9ey8pp5h Жыл бұрын

    Thank you so much for sharing this video ❤

  • @user-so3cd6oc7m
    @user-so3cd6oc7m Жыл бұрын

    Thank you for the interesting explanation

  • @Rob-nb6zi
    @Rob-nb6zi3 ай бұрын

    Excellent tutorial!

  • @ThangTran-hi3es
    @ThangTran-hi3es8 ай бұрын

    I don't know Python but what are you showing is awesome, keep moving!!!!!!!!

  • @carneica

    @carneica

    3 ай бұрын

    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 KZread tutorials like these, online free courses (Harvard CS50 are GREAT!)... and chatGPT... you have it all to learn by yourself! ;)

  • @nubiancenter5918
    @nubiancenter59182 ай бұрын

    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

  • @rzvn111
    @rzvn1119 ай бұрын

    Nice, thank you!

  • @faniescheepers2738
    @faniescheepers27384 ай бұрын

    AMazinglyexplaied. Thank you!!

  • @RVideoR
    @RVideoR Жыл бұрын

    شكرا لك 🙂👍🌷 .. Thank you hala ❤

  • @odivergente388
    @odivergente388 Жыл бұрын

    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

  • @Lemmy13
    @Lemmy136 ай бұрын

    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

  • @Lemmy13

    @Lemmy13

    6 ай бұрын

    Sry for my horrifying grammar

  • @bigrevkev55
    @bigrevkev557 ай бұрын

    Thank you very much!

  • @eimar5652
    @eimar5652 Жыл бұрын

    Really Interesting

  • @kaisj7
    @kaisj710 ай бұрын

    Thank YOU and chokran HALA

  • @cmrncrick
    @cmrncrick11 ай бұрын

    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?

  • @farhanfaraan1
    @farhanfaraan16 ай бұрын

    So informative video.

  • @xipepe
    @xipepe Жыл бұрын

    All I can say is thank you

  • @geraldclark5079
    @geraldclark5079 Жыл бұрын

    Super Like!

  • @nguyenduyta7136
    @nguyenduyta7136 Жыл бұрын

    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 🙏🙏🙏

  • @ahem2784
    @ahem2784 Жыл бұрын

    Thanks sister you give me best idea your realy thanks

  • @carstenjensen3123
    @carstenjensen3123 Жыл бұрын

    Nice!

  • @Ibrahim_Adam1717
    @Ibrahim_Adam17178 ай бұрын

    She is super amazing.

  • @metomeid1693
    @metomeid1693 Жыл бұрын

    ...nice.thank you

  • @kanurimani8536
    @kanurimani85369 ай бұрын

    I love you so much ❤

  • @its_code
    @its_code Жыл бұрын

    💕💕💕💕 very helpful ❤️❤️❤️❤️

  • @codefirstwithhala

    @codefirstwithhala

    Жыл бұрын

    Glad it was helpful! Thanks for the support :)

  • @Ikxi
    @Ikxi Жыл бұрын

    god that tkinter ui looks so much better than mine gonna need to figure out how to do that

  • @raymondmichael4987
    @raymondmichael4987 Жыл бұрын

    Very presentable; one question though, can we use something like googlesheet or synchronize the excell with some sort of cloud database? Btw thanks

  • @RafaelAmigoDoFelipeNeto
    @RafaelAmigoDoFelipeNeto5 ай бұрын

    thank you

  • @richardboreiko
    @richardboreiko10 ай бұрын

    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?

  • @kapibara2440
    @kapibara24404 ай бұрын

    Cool video, learned a lot from it ❤❤❤

  • @kamndaliraphiri7741
    @kamndaliraphiri77413 ай бұрын

    Just looking at the comments I subscribed and shared the video for future use

  • @raymundofelipeolvera5594
    @raymundofelipeolvera559414 күн бұрын

    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?

  • @LastbornAmw1
    @LastbornAmw1 Жыл бұрын

    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.

  • @ianhall2948
    @ianhall29483 ай бұрын

    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.

  • @rabieabed3360
    @rabieabed336011 ай бұрын

    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

  • @eh1273
    @eh1273 Жыл бұрын

    How did you import the excel file like what appears in the left side bar in Pycharm?

  • @aminegatou4492
    @aminegatou4492 Жыл бұрын

    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?

  • @PANDURANG99
    @PANDURANG99 Жыл бұрын

    What about long text in tkinter, want to wrap it but don't have adjustable row height

  • @mohittyagi1596
    @mohittyagi1596 Жыл бұрын

    nice

  • @mikekhattab8729
    @mikekhattab87294 ай бұрын

    Firstly, thank you for your tutorails. I would like to ask what font do you use?

  • @user-cp1xt5de8h
    @user-cp1xt5de8h7 ай бұрын

    hi how did u get the treeview theme ? is there a style cript or something ?

  • @Eirstream
    @Eirstream9 ай бұрын

    @Code First with Hala, nice video, please say: how to edit and values at the treeview??? thank you

  • @aurainaejaz2080
    @aurainaejaz208011 ай бұрын

    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?

  • @nicolamelacca9321
    @nicolamelacca9321 Жыл бұрын

    is there a way to resize the switch button? I don't know why, but it looks super small on my screen

  • @bubz5012
    @bubz5012 Жыл бұрын

    How would you go about creating a button to delete the last entry

  • @bechirzouaoui5821
    @bechirzouaoui5821 Жыл бұрын

    Can you do a vidéo about filtering those data ? Or maybe loading theme from oracle database pliz

  • @omaral-jobory4224
    @omaral-jobory422411 ай бұрын

    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

  • @matiascavalcante4698
    @matiascavalcante4698 Жыл бұрын

    Great video! Can you in the future make a video about classes in Python?

  • @codefirstwithhala

    @codefirstwithhala

    Жыл бұрын

    Hi Matias, sure thing :) Coming soon!

  • @thebudaxcorporate9763
    @thebudaxcorporate9763 Жыл бұрын

    it is compatible with qrcode scan and then data show on grid at right side? need advise

  • @darshang7190
    @darshang71904 ай бұрын

    how to dynamically resize the rows based on the lines each excel row?

  • @abderrahimfouad2133
    @abderrahimfouad2133 Жыл бұрын

    Hi hala how we can make entry field mandatory to enter some text?

  • @safe_side874
    @safe_side87410 ай бұрын

    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' ,, 🙂👍

  • @pepper9372

    @pepper9372

    8 ай бұрын

    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

  • @aambat
    @aambat Жыл бұрын

    Could you please upload a video to connect splash screen with another dialog for qt designer pyqt5

  • @gabort.6838
    @gabort.6838 Жыл бұрын

    Hy! I downloaded the code and when I switch between dark and light mode the window always gets wider. Why is this?

  • @nabiladamou5118
    @nabiladamou511810 ай бұрын

    please how to get the git folder ????

  • @adityajambekar4278
    @adityajambekar4278 Жыл бұрын

    I have an excel file with highlighted cells can I view it on tkinter gui

  • @kuroshnazari6053
    @kuroshnazari605310 ай бұрын

    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 🙏🏻♥️

  • @planetearth2363
    @planetearth2363 Жыл бұрын

    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?

  • @djladieslove1
    @djladieslove110 ай бұрын

    Where can I find a prof as smart as you 👏🏽

  • @vasbkamarxil1260
    @vasbkamarxil1260 Жыл бұрын

    fire

  • @user-ih7ot7vl8u
    @user-ih7ot7vl8u Жыл бұрын

    How can we navigate Excel sheet in the tk windows?

  • @md.minhaz3878
    @md.minhaz38784 ай бұрын

    How we can use pyinstaller to make it executable?

  • @avishek152
    @avishek152 Жыл бұрын

    Hello Hala, Can these rows can be edited?

  • @WinnerSingh
    @WinnerSingh Жыл бұрын

    Nice project Can you make a web app for food order system in python

  • @srijanchakraborty7260
    @srijanchakraborty7260 Жыл бұрын

    list_values = list(sheet.values). my problem is Cannot access member "values" for type "_WorkbookChild". How can i solve this

  • @panchanandgupta6953
    @panchanandgupta69535 ай бұрын

    How to use radiobutton to check if person is employed or unemployed? or for any other data using radio buttons? Anyone

  • @stephenogochukwu9446
    @stephenogochukwu9446 Жыл бұрын

    How can I get forest_light and forest_dark

  • @HeavyTricks
    @HeavyTricks Жыл бұрын

    Please do this in custom tkinter library. Thank you.

  • @ferrc5166
    @ferrc5166 Жыл бұрын

    Anyone tried this but with several spreadsheets? I'm stucked tryin to do that

  • @jhundarrelsagrado6134
    @jhundarrelsagrado6134 Жыл бұрын

    Help how to download the theme and how to apply it on python

  • @asfandiyar5829
    @asfandiyar58299 ай бұрын

    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.

  • @kumaresansp.

    @kumaresansp.

    7 ай бұрын

    Getting the same error when the folder is in the same directory, Any suggestions?

  • @cdimxl

    @cdimxl

    Ай бұрын

    Same error

  • @user-wl2fl4ie8x
    @user-wl2fl4ie8x2 ай бұрын

    Could it cause you to develop diabetes due to algorithms, and the result comes out as an employee or not, meaning zero or one, and store it in an Excel file?

  • @XPACE_Integrated_Agri
    @XPACE_Integrated_Agri Жыл бұрын

    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"" ?

  • @timecop79
    @timecop7911 ай бұрын

    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

Келесі