FANTASTIC video! In the first 3 minutes and 20 seconds you've taught the entire concept of PySimpleGUI. You're really good at this! 💖 the style, the clarity, the animations, and so much more about what you've done.
Thank you so much for your comment & this fabulous and simple to use library. I simply love it - with just a few lines of code, we can add a GUI to our program without messing around with the underlying frameworks. So clever and very well done! 😃👍
@@CodingIsFun Very nice. I have just started learning PySimpleGUI, last month. I want to build a project for my niece for garment shop. Hope I will achieve it soon with the help of experts like you. Thanks a lot. Keep it up.
This is the correct benchmark of technical teaching - I wish more technical trainers could adopt your clear framework for breaking down technical concepts for coding - thank you !
By far this is the best tutorial video I have seen, clear instructions, demonstrations in theory behind each concept and easy to follow bite size steps, learnt more in this short video then in some hour long ones. Thank you for taking the time to produce this and share your expertise with the Community
@@dishangmehta4397 Thanks for watching the video & your video suggestion. Sounds like an exciting video topic. I cannot make any promises, but l will see what I can do.
@GYAAN TECH Thanks for watching the video. In the PySimpleGUI Cookbook, there is an example of how to save the input: 'Recipe - Save and Load Program Settings' pysimplegui.readthedocs.io/en/latest/cookbook/ Regarding the multiline input box: As mentioned in the video, please have a look at the 'Demo' folder. PySimpleGui offers the following widget: sg.Multiline(default_text='This is the default Text should you decide not to type anything', size=(35, 3))
WOW I am impressed. This video is friendly and right to the point. Love it. In 10 minutes I learnt more stuff than reading any book on this topic. Excellent Job!
This is a great video. I am a beginner at using python and coding. This will help me understand what a GUI is and allow me to create something nice for work. Thanks a lot!
I am a novice, and I need guidance on how to install the Command Prompt. The Windows Command Prompt returns errors only. Thank you. BTW. Great job! Straight to the point, and it is exactly what I needed. Regrettably, I am not a programmer and I have difficulties to install the tools to code and follow your instructions. Thanks again.
Hello Sven, I can just add another positive reaction to all the others you already received, WOW WOW what a great tutorial! Thanks for this amazing work and I guess the Python community should build a statue for you! Regards, Frank
@@CodingIsFun Although there is a problem i hope you can help me with , the script wont convert to .exe , whenever i tried it says (IndexError: tuple index out of range) , dist folder is empty as well everything is updated i'm using Visual Studio and the script work fine with Visual Studio and from the Command prompt I would really appreciate if you know the answer Regards
you just got another subscriber , this is so useful and relevant in my field of work . Just started out with python and your explanation is so clear and concise . Thank you brother.
Xlent video.. ❤️simple and clear Sven..U shortened my learning with this video.. if possible.. please make video on update, search and delete options on this topic itself...which will enhance knowledge of ur followers. ❤️ My advanced wishes...
Thank you for the video. I was using the append with concat when I was trying Web Scraping, but it was very confusing when dealing with multiple page scrapes because I'm a beginner. I saw someone with pdf extraction use something called a namedtuple for combining values, and appending a list which is then put into a dataframe. That method seemed simpler to me.
Amazing tutorial. Thanks for your work. I have a question tho. What should I do if i need some of the fields of the excel file to be filled always with the same data? I'll explain this. I have to worl with a boring CSV File in wich i have to manually fill only 2 or 3 cells, and the remaining (a total of 10 in a line) they have always the same data. A boring work of copy/paste for hundreds of lines. This will help me a lot if I could apply your teaching on my needs. Thank you
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
I was looking for a way to get data from and Excel file to use in an online web form filling. I've done this successfully using Power Automate Desktop but now I don't have a license. Looked at AHK but without the coding skill it's beyond my scope for now. Watched your video using chatGPT to write Python automation BUT I guess this is a bit more challenging as each input field needs to be mapped in Python. How deep would this be?
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Here are the docs regarding adding images: docs.pysimplegui.com/en/latest/documentation/module/elements/image/ I'm not sure what you mean by hosting it locally - sorry! Cheers, Sven ✌️
Hello Man, The way you are explaining is excellent!!! Thanks a lot, Please tell me Do you have similar tutorial or code where Data Entry is My SQL intesad of excel? Thanks in advance
Great video Thanks for this, I have one question y supossed that when I share the exe file needs to be with the excel and has to be in the same path right? To change this path I could implement other window with option to change the path or the file to append data?
Thanks for watching. You are right. Currently, the application is looking for an Excel file in the same folder. Yet, you can select the Excel file dynamically by inserting the 'FileBrowse' Element: pysimplegui.readthedocs.io/en/latest/call%20reference/ www.screencast.com/t/64AUEVrzN I hope it helps! Happy Coding! :)
Subscribed! Thank you so much for the tutorial, I'm just a beginner in python but this really helped me building a simple database. It could be useful to upgrade the form allowing to modify the excel data once they are stored. Could you point me in the right direction? Thanks again!
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
amazing video, one of the most valuable 3min i spent on youtube. would you show how we read combo information from mySQL db instead of hard code it in the program? thanks
Thanks for watching the video. Happy to hear that you found the video valuable. In essence, PySimpleGUI is 'just' used to create the GUI. If you want to manipulate a MySQL database, I would suggest coding out your pure Python script first (without GUI). Once you got your CRUD (Create/Read/Update/Delete) functions in place (or whatever you want to do) when you can build the GUI using PySimpleGUI. To get started with MySQL + PySImpleGUI, check out the following post: stackoverflow.com/a/622308 Happy Coding! 🚀
THX! for the video, is there a use and input box to add numbers to multiple certain cell location within the CSV file? For the file I need to create, there is a value that need to input to multiple location within the CSV. So one input multiple output in different locations within the CSV.
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Hello! Excellent presentation! But I got a few questions. How I Can add a timestamp in a separate Excel column every time someone click on Submit? Thank you!
Hi Alex. Thanks for watching. I have created the following solution for you: gist.github.com/Sven-Bo/71251c76e3e3e7183dc6135b371f8c14 Hope you like it! Happy Coding!
Hi great video, clear and concise. I do have one question though, having watched several videos on this kind of topic, I have noticed that Excel and Word files are used, why not Libre Office files?
Hey ...question....(awesome tutorial btw...)...can the executable file be placed anywhere in the computer and it will add to the excel sheet (like in the desktop) or it has to be in the same folder as the excel sheet? Does data entry.py has to also be in same folder? Thank you for any reply.
Thanks! The Excel file does not need to be in the same directory. You need to adjust the following to your needs: current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd() EXCEL_FILE = current_dir / 'Data_Entry.xlsx' df = pd.read_excel(EXCEL_FILE)
Thanks for watching. Yes, it is possible to perform calculations before inserting the data into Excel. You can do this by manipulating the data in the "values" dictionary or the "new_record" DataFrame. Happy Coding!
Please explain how I can program in Python a button inside my application to select files, that is, when I click on it, I can choose files from the device? Then we modify it without opening the file "...I mean excel files
Hi Sven! Thank you so much for such an informative video! I have a question: what happened if we have multiple sheets in our excel file we want to enter the data into instead of the default sheet 1? Thank you in advance!
Thank You so much for the video, it was very helpful. Exactly what I was looking for to complete a project at work. But I have a question, after generating that "little application" that prompt our form, how do I share it with other people?
Thank you for this, I'll be using this as my base code, very simple to understand and follow along... Would it be possible for you to do a tutorial extending this with a pdf file viewer at the side of the entry form, I would like to make something like this but with two panes/section, 1 section for the data entry form and the other for viewing a pdf file... thank you!
Hey there, thanks for watching and for your kind words! I'm glad you found the tutorial easy to follow. While I might not create a specific tutorial for your use case, I encourage you to check out my advanced PySimpleGUI tutorial here: ruclips.net/video/LzCfNanQ_9c/видео.html. By combining the techniques from both tutorials and experimenting on your own, you should be able to achieve your desired layout with a data entry form and a PDF viewer. Good luck, and happy coding!
@@CodingIsFun wow that was fast, thanks for taking time to reply, I've already modified the code to include the fields I needed and it's working without errors, I have 0 knowledge of python and was trying to make something like this by asking Chatgpt but was not successful, your code just works! I'll be checking out the video you mentioned hopefully I could integrate the pdf viewer part successfully too, many thanks again...
Hello, thank you very much for the video and for the clarity of its message. May I ask you if there is any chance to import (in to excel file) only some data leaving the GUI as is?
@@CodingIsFun Hello, thanks a lot for your quick reply. Much appreciated. btw, in your example, you consider five "element" of information (i.e : Name, City, Favorite color, spoken language and n° of children). my question is: is it possible to save in the excel file only some of them (e.g.: Name and n° of children)?
amazing video Sven! i was wondering if there is way to work whit an excel that has two cells merged as a heading and inside that there are two different attributes. for ex: sales on row 1: columns 1,2; and row 2, column 1 is price, column 2 is quantity. when i put the key as price or quantity it makes a new column with these heading, can i point the program to read row 2?
Thank you very much. For retrieving/editing data, have a look at the following short example: ruclips.net/video/RnTqlKzQhRY/видео.html I hope this helps!
Hello Sven, I appreciate the video it immensely helped me navigate the pandas module. I have one question about pysimplegui. When I try to offline no console i can not execute the file. I get an error that states that my excel file is uncallable. How would I ensure my excel file is included in the offline program or even if i were to put the program onto another computer how would i ensure the spreadsheet is mapped correctly. Thank you for your help I hope to hear back soon.
Hi Colt. Thanks for watching. Happy to hear that the video was helpful. Regarding your question, please try the following (assuming you took the latest code from the GitHub repo:): Remove: current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd() Add: current_dir = Path.cwd() ..and try again. I hope it helps! Happy Coding!
So I was wondering here and I would not know how to code. What if im going to enter information of a person or business, just to find out the business or person is already in the excel form? What could I do if I wanted to browse for a file and then click "enter" and then voila, all the pertinent fields would be filled automatically? Is this a hard thing to accomplish?? On and off I stop by because I simple love everything you do here, congratulations and thank you for all !!!!
Thanks for watching and for your question. That is possible. A while ago, I created a quick example that shows you how to retrieve values from the Excel file. You can find it here: ruclips.net/video/RnTqlKzQhRY/видео.html While it is not exactly what you want, I hope it is a good starting point. Happy Coding! :)
Thanks for the video, I have a question.. I want my header row in EXCEL to have some color, with BOLD and bigger text , so i saved the Excel sheet header with a color, but the moment i ran the script header color is reverting back. How to fix it?
Thanks for watching. In the current code, you always create a new Excel file. Hence, all your formatting is gone when submitting the form. You could use the openpyxl library to only add the new data to an existing sheet. I do not have the time to code an example for you, but hopefully, it points you in the right direction. Happy Coding!
ارجوا منك ان تشرح كيف يمكن أن أبرمج بلغة البايثون زر داخل تطبيقي لاختيار الملفات، أي عند النقر عليه يمكنني من اختيار ملفات من على الجهاز؟ ثم نقوم بالتعديل عليها بدون فتح الملف" ...اقصد ملفات الاكسال
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet/documentation for a solution. Sorry that I cannot help!
This is a great video, I do have one question. My df = df.append(values, ingore_index=True) is throwing an AttributeError: 'DataFrame' object has no attribute 'append'. Did you mean: '_append'?
Thanks for watching the video & your video suggestion. You might want to check out the following article on how to work with multiple windows using PySimpleGUI: www.blog.pythonlibrary.org/2021/01/20/pysimplegui-working-with-multiple-windows/ I hope this helps! Happy Coding! 😀
Awesome video! Would there a way to only enter data if approved from a certain user? This is something I am trying to build at work with an approval by certain user layer before it is added to data entry register.
Thank you! You could retrieve the current user as follows: import getpass getpass.getuser() Once you know the user name, you can validate their access using a database. I hope it helps! Happy Coding!
I made a practice with the video y it works perfectly... Thank you very much, so i have a question: it's possible to make the same program but with an Excel file macros enable? I mean, with a file.xlsm? a can i call it from de excel file?
Thanks for watching. No, it does not work with Macro enabled workbooks (xlsm). In that case, you could try to use the 'openpyxl' module, instead of pandas. Happy Coding!
![Tkinter Data Entry Form tutorial for beginners - Python GUI project [responsive layout]](http://i.ytimg.com/vi/vusUfPBsggw/mqdefault.jpg)
![Tkinter Data Entry Form tutorial for beginners - Python GUI project [responsive layout]](/img/tr.png)
FANTASTIC video! In the first 3 minutes and 20 seconds you've taught the entire concept of PySimpleGUI. You're really good at this! 💖 the style, the clarity, the animations, and so much more about what you've done.
Thank you so much for your comment & this fabulous and simple to use library. I simply love it - with just a few lines of code, we can add a GUI to our program without messing around with the underlying frameworks. So clever and very well done! 😃👍
@@CodingIsFun Very nice. I have just started learning PySimpleGUI, last month. I want to build a project for my niece for garment shop. Hope I will achieve it soon with the help of experts like you. Thanks a lot. Keep it up.
This is the correct benchmark of technical teaching - I wish more technical trainers could adopt your clear framework for breaking down technical concepts for coding - thank you !
Thanks for the kind words! I am glad you enjoyed it.
Seriously I loved it. No one has this organized tutorial with documentation as implementation.... I'm in love
Thank you so much for your kind feedback! :)
Thank you very much! I tried it on and it worked very well here from Start to Finish. I entered the data using Portuguese symbols and worked fine.
Glad to hear you liked it and that it is working! Thank you for commenting and watching. -Sven ✌️
By far this is the best tutorial video I have seen, clear instructions, demonstrations in theory behind each concept and easy to follow bite size steps, learnt more in this short video then in some hour long ones. Thank you for taking the time to produce this and share your expertise with the Community
So happy to hear that you found the video helpful. Thank you very much for watching the video and taking the time to leave a comment! :)
🤷♂️ Do you have any questions or need further support? Let me know in the comments 😃
Can you please make a tutorial on how to store inputs received from PyQt5 inputs to mongoDB??
@@dishangmehta4397 Thanks for watching the video & your video suggestion. Sounds like an exciting video topic. I cannot make any promises, but l will see what I can do.
@GYAAN TECH Thanks for watching the video. In the PySimpleGUI Cookbook, there is an example of how to save the input:
'Recipe - Save and Load Program Settings'
pysimplegui.readthedocs.io/en/latest/cookbook/
Regarding the multiline input box:
As mentioned in the video, please have a look at the 'Demo' folder. PySimpleGui offers the following widget:
sg.Multiline(default_text='This is the default Text should you decide not to type anything', size=(35, 3))
What more can I add than what has mentioned many times before? Simply a FANTASTIC video!! Thank you for your wonderful contribution.
Loved reading your comment! Thanks for the support! 👍❤️
WOW I am impressed. This video is friendly and right to the point. Love it. In 10 minutes I learnt more stuff than reading any book on this topic. Excellent Job!
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. Cheers, Sven ✌️
Bro, seriously, you are really the god of coding to me , it was the best tutorial i have ever seen
Thank you, mate! Happy to hear that the video helped you. Happy Coding! Cheers, Sven ✌️
This is a great video. I am a beginner at using python and coding. This will help me understand what a GUI is and allow me to create something nice for work. Thanks a lot!
Thank you for watching the video. I am glad to hear that the video was helpful. Happy coding! 😃👩💻
Super impressed! Finally a clear demo of how to build a UI that writes to Excel via python. Thank you!
Hi Dennis G D! Happy to hear that you liked the video. Thanks for watching and taking the time to leave a comment! :)
Awesome sir god bless you
You explained it simply amd effectively and more important clearly
Thank you sir 🙏🏻
Thanks for leaving a comment! Happy you enjoyed the video! 🙏
Love the voice/accent. Cross between a man child and very intelligent man. Love the vids too. Will sub
Hey Chris! Thanks for watching and subscribing, welcome aboard! 👍
I am a novice, and I need guidance on how to install the Command Prompt. The Windows Command Prompt returns errors only. Thank you.
BTW. Great job! Straight to the point, and it is exactly what I needed. Regrettably, I am not a programmer and I have difficulties to install the tools to code and follow your instructions. Thanks again.
Thanks for watching. The actual error message would be helpful if you would like some guidance. Thanks! Cheers, Sven ✌️
Pythons for business in a nutshell 🤯🤯 So many ideas to work with this base...thanks
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
This video is awesome. The concision, clarity and simplicity put in the explanations are impressive! Thanks and please do keep up!!!
Thank you so much for your positive feedback! I appreciate it! 😃
Good job on the video! Clear, concise and good presentation. I really like the code animations. Looking forward to watching more of your videos.
Thank you. Glad you like the video :)
Didn't know this was possible so easily. Very practical!
Thank you for watching the video, Florian. Glad it is helpful!
Very well explained!! Thank you!
Glad you liked it. Thanks for watching. Cheers, Sven ✌️
i am python biggner,
thanks and more helpful
Glad you liked it. Thanks for watching.
One of the best tutorials I have seen. Thank you
Thank you!
Combining this concept within a streamlit app [taking user input and recording into an excel spreadsheet] would be first class.
Thank you for watching the video & your suggestion.
i enjoy all your tutorials. this was the 4th i have followed along. i am learning so much
I am happy to hear that you have been finding the videos helpful. Thanks for taking the time to leave a comment and for watching!
I'm soooooooooooooo happy to see this. Much needed video. I was searching for this only.
Glad you found it. Hope it is helpful :)
This is top notch content ..hope you gain more subscribers
Thank you 😃🙏
Thinking about the many ways I could use this method.
Thank you so much for this. Please keep up the tremendous work.
This one's a real gem.
*I am glad you liked the video; thanks for watching and the kind words.* 😀
As always, your content is pure gold!
Thank you for your kind words :)
Man I wish I'd found your channel earlier!!! This is super useful!!!
Happy to hear that you find the video useful! Thanks for watching and commenting! :)
This is so fun, thank you so much! I'm happy I found this channel!
Happy to hear that you liked the video!
Sorprendente, es un super video, breve claro, práctico y muy educativo. Muchas gracias
Thanks for the kind words! Glad to hear you found the video helpful and educational. 👍
Best tutorial on the net
Thanks for the kind words! I am glad you enjoyed it. 👍
Hello Sven, I can just add another positive reaction to all the others you already received, WOW WOW what a great tutorial! Thanks for this amazing work and I guess the Python community should build a statue for you!
Regards, Frank
Hey Frank,
Thanks for watching and leaving such a kind comment! I really appreciate it. 🙏
I'm glad you found the tutorial helpful. Happy Coding! 🚀
Most clear and cleaver video I've ever seen >>>>>> good job
Thank you very much! :)
@@CodingIsFun Although there is a problem i hope you can help me with , the script wont convert to .exe , whenever i tried it says (IndexError: tuple index out of range)
, dist folder is empty as well
everything is updated
i'm using Visual Studio and the script work fine with Visual Studio and from the Command prompt
I would really appreciate if you know the answer
Regards
This is great! I would like to know if we share the file and employees fill on their desktop if the information start updating on its own
Thanks for watching. Sorry, but I am not sure what you mean.
Super!!explained in a very simple way but very effective..so many things learnt in a such a small video!!great work sir!!
Happy to hear that. Thanks for watching and your kind words!
you just got another subscriber , this is so useful and relevant in my field of work . Just started out with python and your explanation is so clear and concise . Thank you brother.
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Xlent video.. ❤️simple and clear Sven..U shortened my learning with this video.. if possible.. please make video on update, search and delete options on this topic itself...which will enhance knowledge of ur followers. ❤️ My advanced wishes...
Thanks for your kind words & video suggestion! I appreciate it! :)
We have same opinion and waiting.
Love it I already reply this project it work 🎉
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
congratulations, thank you for sharing your knowledge
Thank you for watching the video and taking the time to leave a comment! 👍
Thank you for the video. I was using the append with concat when I was trying Web Scraping, but it was very confusing when dealing with multiple page scrapes because I'm a beginner. I saw someone with pdf extraction use something called a namedtuple for combining values, and appending a list which is then put into a dataframe. That method seemed simpler to me.
Thank you for watching the video and taking the time to leave a comment!
Very Good!
There is a complete application with Save, Read, Update and Delete.
Thanks!
No, I do not have a 'complete' CRUD application.
@@CodingIsFun Great!
Amazing tutorial. Thanks for your work. I have a question tho. What should I do if i need some of the fields of the excel file to be filled always with the same data?
I'll explain this. I have to worl with a boring CSV File in wich i have to manually fill only 2 or 3 cells, and the remaining (a total of 10 in a line) they have always the same data. A boring work of copy/paste for hundreds of lines. This will help me a lot if I could apply your teaching on my needs.
Thank you
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Fantástic video. Thanks you very much. One question: what IDE you use? I'm using Visual studio code...
Thank you. In the video I used 'Atom'.
Amazing tutorial and truly i am very much impressed for your knowledge and sharing such a beautiful content to Enthusiast Pythonist developers.
Happy to hear that you liked the video; thank you for taking the time to leave a comment and for watching the video! 👍
@@CodingIsFun sir not only liked your video, subscribed.as well
Awesome work 😀
Thank you!
Wow you made that so easy to understand. This topic was intimidating for me being new to coding. Thank you for the vid :)
Glad to hear you liked it! Thank you for commenting and watching. 😃
Bro you are great. You taught exactly what I needed. Love you man
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍
I was looking for a way to get data from and Excel file to use in an online web form filling. I've done this successfully using Power Automate Desktop but now I don't have a license. Looked at AHK but without the coding skill it's beyond my scope for now. Watched your video using chatGPT to write Python automation BUT I guess this is a bit more challenging as each input field needs to be mapped in Python. How deep would this be?
Thank you❤, really appreciate your efforts
Glad you liked it. Thanks for watching.
You explain really well. I’m feeling motivated to automate a task
Thank you for watching the video and taking the time to leave a comment. I am glad you liked the video.
This is great! Is there any way to add a field of day/date that would automatically update without having to input it each time?
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Wow .very nice video...thanks ..
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
This was beautifully taught.
Thank you.
Thanks for the kind words! I am glad you enjoyed it. 🤩
Thanks for this great example.
An absolute pleasure, very happy to hear that you found it useful! 👍
Excellent video! Thanks for the help!!
Glad I could help! Thanks for watching! 👍
This is great. Is there a way to add images and host it locally?
Here are the docs regarding adding images: docs.pysimplegui.com/en/latest/documentation/module/elements/image/
I'm not sure what you mean by hosting it locally - sorry! Cheers, Sven ✌️
What is amazing video, many thanks!
Glad you liked it. Thanks for watching and taking the time to leave a comment!
Hello Man, The way you are explaining is excellent!!! Thanks a lot, Please tell me Do you have similar tutorial or code where Data Entry is My SQL intesad of excel? Thanks in advance
Thanks for watching. Nope, I do not have a tutorial on that topic.
Great video Thanks for this, I have one question y supossed that when I share the exe file needs to be with the excel and has to be in the same path right? To change this path I could implement other window with option to change the path or the file to append data?
Thanks for watching. You are right. Currently, the application is looking for an Excel file in the same folder. Yet, you can select the Excel file dynamically by inserting the 'FileBrowse' Element:
pysimplegui.readthedocs.io/en/latest/call%20reference/
www.screencast.com/t/64AUEVrzN
I hope it helps! Happy Coding! :)
Thanks for the video. I am going to start using this. Good work! Hope to see more tutorials.
Thanks for watching the video and taking the time to leave a comment! :)
Subscribed! Thank you so much for the tutorial, I'm just a beginner in python but this really helped me building a simple database. It could be useful to upgrade the form allowing to modify the excel data once they are stored. Could you point me in the right direction? Thanks again!
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
amazing video, one of the most valuable 3min i spent on youtube.
would you show how we read combo information from mySQL db instead of hard code it in the program?
thanks
Thanks for watching the video. Happy to hear that you found the video valuable.
In essence, PySimpleGUI is 'just' used to create the GUI. If you want to manipulate a MySQL database, I would suggest coding out your pure Python script first (without GUI).
Once you got your CRUD (Create/Read/Update/Delete) functions in place (or whatever you want to do) when you can build the GUI using PySimpleGUI.
To get started with MySQL + PySImpleGUI, check out the following post: stackoverflow.com/a/622308
Happy Coding! 🚀
THX! for the video, is there a use and input box to add numbers to multiple certain cell location within the CSV file? For the file I need to create, there is a value that need to input to multiple location within the CSV. So one input multiple output in different locations within the CSV.
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Well done nice little video! Thanks for this!
Glad you enjoyed it! Thanks for watching and taking the time to leave a comment! 👍
This is very useful. Thanks Sven!
Thank you! Glad you like the solution!
...wow..Very good video...thank...
Thank you! :)
Hello! Excellent presentation!
But I got a few questions.
How I Can add a timestamp in a separate Excel column every time someone click on Submit?
Thank you!
Hi Alex. Thanks for watching. I have created the following solution for you: gist.github.com/Sven-Bo/71251c76e3e3e7183dc6135b371f8c14
Hope you like it! Happy Coding!
Very beautifully explained....very informative
Thanks for the kind words! I am glad you enjoyed it.
Awesome, thank you.
You're very welcome! Thank you for watching and for the comment!
Thanks for making this so simple to understand
Glad it was helpful! Thanks for watching the video & taking the time to leave a comment :)
Hi great video, clear and concise.
I do have one question though, having watched several videos on this kind of topic, I have noticed that Excel and Word files are used, why not Libre Office files?
Simple answer for my videos: I only have MS Office installed ;)
Hey ...question....(awesome tutorial btw...)...can the executable file be placed anywhere in the computer and it will add to the excel sheet (like in the desktop) or it has to be in the same folder as the excel sheet? Does data entry.py has to also be in same folder? Thank you for any reply.
Thanks! The Excel file does not need to be in the same directory.
You need to adjust the following to your needs:
current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd()
EXCEL_FILE = current_dir / 'Data_Entry.xlsx'
df = pd.read_excel(EXCEL_FILE)
This is great! Thank you a lot!
My pleasure! Appreciate you taking the time to watch and leave a comment.
I love your channel
It's very kind of you to say so, thank you! 🙏
Thanks for the helpful video! is it possible also to make some calculations before insert the data into the excel? How to do it? thks
Thanks for watching. Yes, it is possible to perform calculations before inserting the data into Excel. You can do this by manipulating the data in the "values" dictionary or the "new_record" DataFrame. Happy Coding!
Please explain how I can program in Python a button inside my application to select files, that is, when I click on it, I can choose files from the device? Then we modify it without opening the file "...I mean excel files
Check out the following tutorial: ruclips.net/video/_H5hsUwv8lE/видео.html
I hope it helps! Happy Coding!
Hi Sven! Thank you so much for such an informative video! I have a question: what happened if we have multiple sheets in our excel file we want to enter the data into instead of the default sheet 1? Thank you in advance!
You could export it to an existing/specific sheet. Here is an example of how to do it in Pandas: ruclips.net/video/DroafWQXqDw/видео.html
that was very well done! thanks for this! so glad i know about PySimpleGUI now!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍
Thank You so much for the video, it was very helpful. Exactly what I was looking for to complete a project at work. But I have a question, after generating that "little application" that prompt our form, how do I share it with other people?
7:40 min
Thank you for this, I'll be using this as my base code, very simple to understand and follow along... Would it be possible for you to do a tutorial extending this with a pdf file viewer at the side of the entry form, I would like to make something like this but with two panes/section, 1 section for the data entry form and the other for viewing a pdf file... thank you!
Hey there, thanks for watching and for your kind words! I'm glad you found the tutorial easy to follow. While I might not create a specific tutorial for your use case, I encourage you to check out my advanced PySimpleGUI tutorial here: ruclips.net/video/LzCfNanQ_9c/видео.html. By combining the techniques from both tutorials and experimenting on your own, you should be able to achieve your desired layout with a data entry form and a PDF viewer. Good luck, and happy coding!
@@CodingIsFun wow that was fast, thanks for taking time to reply, I've already modified the code to include the fields I needed and it's working without errors, I have 0 knowledge of python and was trying to make something like this by asking Chatgpt but was not successful, your code just works! I'll be checking out the video you mentioned hopefully I could integrate the pdf viewer part successfully too, many thanks again...
Very helpful tutorial, thx a lot!
Thanks for the positive feedback! Appreciate you taking the time to leave a comment.
Hello, thank you very much for the video and for the clarity of its message. May I ask you if there is any chance to import (in to excel file) only some data leaving the GUI as is?
Thanks for watching the video. Can you perhaps elaborate on what it is you're trying to achieve? Please provide some additional info. Thanks!
@@CodingIsFun Hello, thanks a lot for your quick reply. Much appreciated. btw, in your example, you consider five "element" of information (i.e : Name, City, Favorite color, spoken language and n° of children). my question is: is it possible to save in the excel file only some of them (e.g.: Name and n° of children)?
@@giovannitrivieri6722 You could remove the unwanted item/element from the "values" dict, e.g. using del values["City"] before exporting it to Excel.
amazing video Sven! i was wondering if there is way to work whit an excel that has two cells merged as a heading and inside that there are two different attributes. for ex: sales on row 1: columns 1,2; and row 2, column 1 is price, column 2 is quantity.
when i put the key as price or quantity it makes a new column with these heading, can i point the program to read row 2?
i have impressed with your tutorials .please show us save delete and edit button and report generation based on the saved data
Thank you very much.
For retrieving/editing data, have a look at the following short example:
ruclips.net/video/RnTqlKzQhRY/видео.html
I hope this helps!
Hello Sven, I appreciate the video it immensely helped me navigate the pandas module. I have one question about pysimplegui. When I try to offline no console i can not execute the file. I get an error that states that my excel file is uncallable. How would I ensure my excel file is included in the offline program or even if i were to put the program onto another computer how would i ensure the spreadsheet is mapped correctly. Thank you for your help I hope to hear back soon.
Hi Colt. Thanks for watching. Happy to hear that the video was helpful. Regarding your question, please try the following (assuming you took the latest code from the GitHub repo:):
Remove: current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd()
Add: current_dir = Path.cwd()
..and try again. I hope it helps! Happy Coding!
Another great video discover
Happy to hear that you enjoyed this one too! Thanks for the comments! :)
So I was wondering here and I would not know how to code. What if im going to enter information of a person or business, just to find out the business or person is already in the excel form? What could I do if I wanted to browse for a file and then click "enter" and then voila, all the pertinent fields would be filled automatically? Is this a hard thing to accomplish?? On and off I stop by because I simple love everything you do here, congratulations and thank you for all !!!!
Thanks for watching and for your question. That is possible. A while ago, I created a quick example that shows you how to retrieve values from the Excel file. You can find it here: ruclips.net/video/RnTqlKzQhRY/видео.html
While it is not exactly what you want, I hope it is a good starting point. Happy Coding! :)
Thanks for the video, I have a question..
I want my header row in EXCEL to have some color, with BOLD and bigger text , so i saved the Excel sheet header with a color, but the moment i ran the script header color is reverting back. How to fix it?
Thanks for watching. In the current code, you always create a new Excel file. Hence, all your formatting is gone when submitting the form. You could use the openpyxl library to only add the new data to an existing sheet. I do not have the time to code an example for you, but hopefully, it points you in the right direction. Happy Coding!
ارجوا منك ان تشرح كيف يمكن أن أبرمج بلغة البايثون زر داخل تطبيقي لاختيار الملفات، أي عند النقر عليه يمكنني من اختيار ملفات من على الجهاز؟ ثم نقوم بالتعديل عليها بدون فتح الملف" ...اقصد ملفات الاكسال
Check out the following tutorial: ruclips.net/video/_H5hsUwv8lE/видео.html
I hope it helps! Happy Coding!
@@CodingIsFun Thank you
Thank you for share knowledge.Please make same video for invoice genrater.(When we type items name it's show drop down)
Thank you for watching the video & your suggestion.
This is seriously impressive. 👏
Thank you very much!
Awsome,could you.also explain the code by wiritng how to avoid duplicate entries?
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thank you for the simple video and your code. If I want to change the color of the tab after user input is submitted, how do I do this?
Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet/documentation for a solution. Sorry that I cannot help!
@@CodingIsFun NP. Thank you.
This is a great video, I do have one question. My df = df.append(values, ingore_index=True) is throwing an AttributeError: 'DataFrame' object has no attribute 'append'. Did you mean: '_append'?
Thanks for watching. Please use updated code from my GitHub repo. Thanks! -Sven
Great video, subscribed
Thanks for the sub! :)
Very cool!!
Thanks! :)
can you please make video on how to stack screens in PySimpleGUI.
Thanks for watching the video & your video suggestion. You might want to check out the following article on how to work with multiple windows using PySimpleGUI:
www.blog.pythonlibrary.org/2021/01/20/pysimplegui-working-with-multiple-windows/
I hope this helps! Happy Coding! 😀
Awesome video!
Would there a way to only enter data if approved from a certain user? This is something I am trying to build at work with an approval by certain user layer before it is added to data entry register.
Thank you!
You could retrieve the current user as follows:
import getpass
getpass.getuser()
Once you know the user name, you can validate their access using a database.
I hope it helps! Happy Coding!
Hey, really a great tutorial. This I was looking for. Let‘s see if there is also an app to display the content of the excel file.
Thanks! Here is a small example of how to retrieve data: ruclips.net/video/RnTqlKzQhRY/видео.html
Perhaps it already helps. Happy Coding!
I made a practice with the video y it works perfectly... Thank you very much, so i have a question: it's possible to make the same program but with an Excel file macros enable? I mean, with a file.xlsm? a can i call it from de excel file?
Thanks for watching. No, it does not work with Macro enabled workbooks (xlsm). In that case, you could try to use the 'openpyxl' module, instead of pandas. Happy Coding!
@@CodingIsFun Thanks a lot! I will try with openpyxl... So, a can conbine python an vba with that library?