Python Excel Data Entry Form with Tkinter tutorial for beginners - Python GUI project [openpyxl]

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ต.ค. 2024

ความคิดเห็น • 76

  • @MrFrancoA3
    @MrFrancoA3 2 ปีที่แล้ว +16

    I have seen a lot of tkinter tutorials in the last weeks but so far you have been the best teacher, I really think you have a gift to teach in a very clear and concise way. Thank you very much for sharing your knowledge. 😊

  • @astropgn
    @astropgn 6 หลายเดือนก่อน +2

    I'm 35 old guy with high blood pressure and the doctor said I need to log it 3 times a day. Me being me, I had to add all the data into a database, and every measurement is taken 3 times (so 3x3x30 per month!). I made a simple gui program using the info from this video and now I just open it, type the values and it saves it for me. Next time I will create a plot automatically as soon as a new point is added. This knowledge was so helpful!

  • @ss-jy2ig
    @ss-jy2ig 2 ปีที่แล้ว +9

    I just wanna thank you for creating these tutorials. You have no idea how much these tutorials have helped me and many others, I pretty much learned everything I know about pyqt all thanks to your tutorials. Thank you so much Hala!

    • @codefirstwithhala
      @codefirstwithhala  2 ปีที่แล้ว +3

      Thank you so much for your comment 😊It makes me happy to know that at least someone out there is benefitting from these videos. I hope to continue to make more :) thanks again

    • @fk4523
      @fk4523 ปีที่แล้ว

      ​@@codefirstwithhalathanks giving me sach good teaching. Plz start a fresh python course for data science and machine learning. Plz its request. You r really really amazing teacher. love 💕 ur way of teaching Hala. Love 💕 u

    • @fk4523
      @fk4523 ปีที่แล้ว

      ​@@codefirstwithhalaplz convert this app in exe file. When i convert using pyinstaller. It converts but exe file not works.

  • @paulg6094
    @paulg6094 ปีที่แล้ว +5

    Hi I'm in my 60's and I found this tutorial EXCELLENT, especially the way you break everything down. I would love to see a tutorial of a form like you have but with a data entry that has a scrollable grid and where you can read the information back in from the spreadsheet to the scrollable grid. Thanks again for you knowledge!

    • @kakairecharles3474
      @kakairecharles3474 ปีที่แล้ว

      I have just landed in, just a few minutes but I am already very comfortable! She is such a wonderful instructor!

  • @user-yn3zl1fd4k
    @user-yn3zl1fd4k ปีที่แล้ว +2

    Your tutorials are the best Hala! Thx for sharing! Keep up the great work!

  • @ramamurthi7939
    @ramamurthi7939 ปีที่แล้ว +1

    I concur with the rest of the people. You are excellent in presenting this. I will give you 5 stars

  • @JonelAlibasa-zt4mo
    @JonelAlibasa-zt4mo ปีที่แล้ว +1

    Please continue uploading more videos. We really appreciate your work. Ty

  • @Explore4code
    @Explore4code 10 หลายเดือนก่อน

    Super Wow, this Tkinter course is an absolute gem! 👏

  • @Diogene-pl1lq
    @Diogene-pl1lq ปีที่แล้ว

    Waouuuuh Always GREAT teaching as crystal clear. Merci beaucoup Hala

  • @engineeringwithandy6434
    @engineeringwithandy6434 3 หลายเดือนก่อน

    Excellent simple and clear tutorial I have shared this with my students for their Digital Technology assignment as a reference.

  • @jimalix6270
    @jimalix6270 7 หลายเดือนก่อน

    Another outstanding tutorial! Thanks very much!

  • @McGre9or
    @McGre9or ปีที่แล้ว +1

    Great course! Great teacher! Awesome skills learned! Thank you so much Hala! 💯👏💚

  • @chellahkalampaoverseas6221
    @chellahkalampaoverseas6221 9 หลายเดือนก่อน

    You the best❤❤❤❤❤❤❤❤❤❤❤ watching from Zambia

  • @Zak-l7e
    @Zak-l7e ปีที่แล้ว

    i have just finished the previous tutorial, and this is my second one, so far you nailed it, your way of showing and tutoring is fantastic, you take your time and explain code very patiently, not like many others that skip a lot of explaining and assume you know, keep going and do more practical (by example) tutorials please. thank you

  • @dmskarunaratne80
    @dmskarunaratne80 4 หลายเดือนก่อน

    your way is very concise and and clear. Love it.

  • @khaladmohaned2002
    @khaladmohaned2002 ปีที่แล้ว

    you are the best teacher ever ....do more and more please🙂..thank you

  • @micmike
    @micmike ปีที่แล้ว

    Thanks, really enjoyed the lesson. I struggled because i forgot that i had to double slash my filepath so that took a while to resolve and then like a dummy I put the variables names in quotes and so kept getting multiple heading entries but not the data, so after I returned to earth I discovered that and now everything works fine. Much appreciated!

  • @manoharsagunthalla9215
    @manoharsagunthalla9215 10 หลายเดือนก่อน

    You are the one person to make divisions of each part of tkinter and explain tharoghly. Please explain after entering data into the form and press enter data , the form widget should be blank.

  • @patriciascalisse5418
    @patriciascalisse5418 10 หลายเดือนก่อน

    First of all, you are excellent. Although you speak fast is very well understandable in special for people like me which english is not our language. You are really good. Thanks.

  • @michaelallison7259
    @michaelallison7259 ปีที่แล้ว

    Your videos are fantastic, best i have seen for learning python

  • @kidsworld1801
    @kidsworld1801 ปีที่แล้ว

    I am a beginner and i really understood everything which you have taught in the tutorial.Excellent teaching skills you have

  • @fouadmoussa3475
    @fouadmoussa3475 ปีที่แล้ว

    you are a mazing , your tutorial is very clear and inspire all the beginners like me keep going thanks a lot

  • @bellaeke1010
    @bellaeke1010 ปีที่แล้ว

    You're a great teacher Hala. These learning nuggets are golden. Thank you so much!❤

  • @agrnpg
    @agrnpg 2 ปีที่แล้ว

    Thankx for breaking it down.. great tutorial for beginners

  • @sumitkumargupta1720
    @sumitkumargupta1720 ปีที่แล้ว

    Very helpful video. Thank you so much for posting it.

  • @DevrajMutrasi-n1n
    @DevrajMutrasi-n1n ปีที่แล้ว

    thanks form you tutorials i have created this thanks you very much

  • @BillyT83
    @BillyT83 2 ปีที่แล้ว +1

    Clear explanation and amazing presentation!👍

  • @rodrigodesousa7160
    @rodrigodesousa7160 9 หลายเดือนก่อน

    Thanks, Im from Brazil

  • @MohammedYilmaz-tb4cr
    @MohammedYilmaz-tb4cr ปีที่แล้ว

    Thank you so much, your video was very helpful and the best ❤

  • @juniorludima2727
    @juniorludima2727 7 หลายเดือนก่อน

    very helpful video thank you a lot

  • @xujason4607
    @xujason4607 9 หลายเดือนก่อน

    great video , I learned !

  • @funwithlearning9612
    @funwithlearning9612 9 หลายเดือนก่อน

    each and every line of code is Very well explained..... implemented a lot of efforts.......Superb...please add delete and update query to in sqlite project... it would cover everything.... and if possible do make a project where automation is applied with python...Keep up the hard work....

  • @moneyraymondottv
    @moneyraymondottv ปีที่แล้ว

    Your tutorials have been amazing. I've learnt a lot from them

  • @xujason4607
    @xujason4607 10 หลายเดือนก่อน

    that is what I need actually !

  • @patriciascalisse5418
    @patriciascalisse5418 10 หลายเดือนก่อน

    Again excellent.

  • @rickswineberg
    @rickswineberg ปีที่แล้ว +1

    The numbers you are currently entering into excel are formatted as text, how to change the formatting.? Thank you

  • @w4twa
    @w4twa ปีที่แล้ว +1

    Hala, great tutorial. I have a question for you. I use Linux, therefore I’m using Libre suite. Can this be used to do the same in a Libre spreadsheet, or only Excel? Thank you for the videos.

  • @cmrncrick
    @cmrncrick ปีที่แล้ว +1

    Can you clear the data from the entries upon hitting the Enter Data button? So that way you automatically get a clear form for another entry instead of having to delete each field?

  • @tarkhusny1075
    @tarkhusny1075 ปีที่แล้ว

    Great tutorial!

  • @bobciv5171
    @bobciv5171 ปีที่แล้ว

    Thank you so much for making these videos. I was wondering how I would connect this to a Onedrive using excel?

  • @souravbarua3991
    @souravbarua3991 2 ปีที่แล้ว

    very helpful tutorial.Thank u.Please upload video tutorial for retrieving data or search data from excel and autofill using tkinter.

  • @emmanuelakpaklikwasi4300
    @emmanuelakpaklikwasi4300 ปีที่แล้ว

    I really love your tutorials. Well done! But what will happen if i use the pyinstaller to covert it to an application and i install it on a different computer. The reason why am asking is because of the file path. How do i use the pyinstaller in way that i can install on any computer and retrieve the data in excel automatically as you just demonstrated? Or can you make a video on that? Thank you!

  • @Sunilkumar-1564
    @Sunilkumar-1564 10 หลายเดือนก่อน

    thank you so much

  • @lenny95sehs
    @lenny95sehs ปีที่แล้ว +1

    Awesome video! I have subscribed.
    Question: Can this code be converted to a windows exe so those that don’t have python on their computers can complete the same action?
    Question: Is there a way for the GUI to read from excel and populate data from an entry, be edited and entered back in on the same line it came from?

  • @jimhicks1947
    @jimhicks1947 ปีที่แล้ว

    Great video, I really like your tutorials. Somebody below asked the same question I was going to ask, can you clear the form after hitting the "Enter Button" or maybe have a "Next" button that does the same thing. Very happy with your videos...😋

  • @moaz_alibrahim
    @moaz_alibrahim ปีที่แล้ว +1

    What theme name do you use in vscode please

  • @TyphonNeuron
    @TyphonNeuron 8 หลายเดือนก่อน

    How can you insert data in specific cells in the excel file? Great videos and tutorials BTW.

  • @jordanles1766
    @jordanles1766 ปีที่แล้ว

    hi thanx for the tutorial i have a question the form stores the numbers as text in excel which command can i use to auto convert them to numbers in excel without showing errors?

  • @CodePhiles
    @CodePhiles 2 ปีที่แล้ว

    Thank you for your videos

  • @MohannadElMegharbel
    @MohannadElMegharbel ปีที่แล้ว

    Can u advice how to develop an RTL form to accept Arabic input

  • @CodePhiles
    @CodePhiles 2 ปีที่แล้ว

    I think there is some code refactoring needed here , when you check the file existence
    like , if not exist:...create it and add the heading ==> else: ..load it
    then the remaining lines could come afterwards as: for line 41 same as line 35 and line 39 as line 44

  • @batista98854
    @batista98854 2 ปีที่แล้ว +1

    Awesome Thanks again. Please we also want how it goes to DB

    • @codefirstwithhala
      @codefirstwithhala  2 ปีที่แล้ว +1

      Same video but with SQLite coming on Friday!

    • @batista98854
      @batista98854 2 ปีที่แล้ว

      @@codefirstwithhala thanks a lot!!!!!

  • @mohamedalhashmi1386
    @mohamedalhashmi1386 ปีที่แล้ว

    thank you a lot.
    By the way from which country are you from?

  • @assiaben1220
    @assiaben1220 ปีที่แล้ว

    It's really helpful thanks. How can we do the same thing with ms.word? instead of a form a deed template

  • @feadai
    @feadai ปีที่แล้ว +1

    great

  • @mohamedalhashmi1386
    @mohamedalhashmi1386 ปีที่แล้ว

    Thanks!

  • @lamkequoc1
    @lamkequoc1 ปีที่แล้ว

    Great tutorial, thank you for the sharing. However, if you insert again, the employment status doesn't set as "Unemployed" even through the checkbutton is cleared. We need to reset 'a' value to be 'False' as well by adding 'a.set(False)' at the of #clear the values codes

  • @xujason4607
    @xujason4607 10 หลายเดือนก่อน

    Pls keep going anayway .

  • @amanda-janedeagrella5020
    @amanda-janedeagrella5020 ปีที่แล้ว

    Hi Hala please could you make a video like this one but for saving to a csv file

  • @MoMo-lj2ic
    @MoMo-lj2ic ปีที่แล้ว

    How can the widget refresh in python after entering the data instead of closing it down all the time

  • @jamaicaigot9335
    @jamaicaigot9335 2 ปีที่แล้ว

    Thank you for the information, are you also in audea btw? I'd love to listen more of your contents

  • @newlookak47
    @newlookak47 5 หลายเดือนก่อน

    I installed openpyxl. But your code is reporting an error

  • @batista98854
    @batista98854 2 ปีที่แล้ว

    Awesome

  • @AK-ox3mv
    @AK-ox3mv ปีที่แล้ว

    Hey Hala, fun fact:
    "Hala" in Persian mean "now"

  • @martijn34884
    @martijn34884 ปีที่แล้ว

    Hi Hala,
    How do i import the saved data.
    I am building an app so i can make maintenance reports. But if they can finish the work they can save the info and reload. But its impossible to find

  • @topgearIQ
    @topgearIQ 8 หลายเดือนก่อน

    From where country hala

  • @itsAyanAli
    @itsAyanAli ปีที่แล้ว +1

    the first asian john smith I ever seen

  • @bunmi4164
    @bunmi4164 9 หลายเดือนก่อน

    ur video is not clear