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

[@MrFrancoA3]

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]

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!

[@paulg6094]

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]

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

[@ss-jy2ig]

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]

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]

​@@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]

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

[@ramamurthi7939]

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

[@manoharsagunthalla9215]

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.

[@engineeringwithandy6434]

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

[@user-yn3zl1fd4k]

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

[@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

[@JonelAlibasa-zt4mo]

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

[@patriciascalisse5418]

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.

[@Explore4code]

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

[@dmskarunaratne80]

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

[@w4twa]

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.

[@khaladmohaned2002]

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

[@cmrncrick]

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?

[@chellahkalampaoverseas6221]

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

[@Diogene-pl1lq]

Waouuuuh Always GREAT teaching as crystal clear. Merci beaucoup Hala

[@fouadmoussa3475]

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

[@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!

[@kidsworld1801]

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

[@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!

[@McGre9or]

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

[@rickswineberg]

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

[@funwithlearning9612]

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

[@michaelallison7259]

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

[@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?

[@lenny95sehs]

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?

[@jimalix6270]

Another outstanding tutorial! Thanks very much!

[@TyphonNeuron]

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

[@bellaeke1010]

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

[@bobciv5171]

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

[@assiaben1220]

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

[@mohamedalhashmi1386]

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

[@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...😋

[@DevrajMutrasi-n1n]

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

[@agrnpg]

Thankx for breaking it down.. great tutorial for beginners

[@moaz_alibrahim]

What theme name do you use in vscode please

[@MohammedYilmaz-tb4cr]

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

[@sumitkumargupta1720]

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

[@rodrigodesousa7160]

Thanks, Im from Brazil

[@souravbarua3991]

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

[@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

[@MohannadElMegharbel]

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

[@BillyT83]

Clear explanation and amazing presentation!👍

[@codefirstwithhala]

Thank you for watching! :)

[@patriciascalisse5418]

Again excellent.

[@xujason4607]

great video , I learned !

[@xujason4607]

that is what I need actually !

[@juniorludima2727]

very helpful video thank you a lot

[@moneyraymondottv]

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

[@jamaicaigot9335]

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

[@CodePhiles]

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]

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

[@codefirstwithhala]

Same video but with SQLite coming on Friday!

[@batista98854]

@@codefirstwithhala thanks a lot!!!!!

[@amanda-janedeagrella5020]

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

[@xujason4607]

Pls keep going anayway .

[@tarkhusny1075]

Great tutorial!

[@Sunilkumar-1564]

thank you so much

[@MoMo-lj2ic]

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

[@feadai]

great

[@AK-ox3mv]

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

[@mohamedalhashmi1386]

Thanks!

[@CodePhiles]

Thank you for your videos

[@codefirstwithhala]

You’re welcome!

[@newlookak47]

I installed openpyxl. But your code is reporting an error

[@batista98854]

Awesome

[@topgearIQ]

From where country hala

[@itsAyanAli]

the first asian john smith I ever seen

[@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

[@bunmi4164]

ur video is not clear