How to Create an Excel Data Form Using Python + ChatGPT

[@Gdnc09]

Danke ! Ich habe lange nach solchen Programmen gesucht und hart gearbeitet, bis ich etwas Ähnliches gemacht habe.

[@CodingIsFun]

Freut mich zu hören. Danke fürs Zuschauen! Beste Grüße, Sven

[@sheikhraisulislam1979]

Your videos are really attractive and functional

[@CodingIsFun]

*I am glad to hear you are enjoying them, thanks for watching and for the comment!* -Sven ✌️

[@abdullahalmahin9070]

​@@CodingIsFunHello Thanks for the video..hey can you tell me is there a way to make simple data entry form what will connect to excel or google sheet without internet.

[@sujungpark5764]

It is super useful. thank you 😁

[@CodingIsFun]

You're welcome 😊 Thanks for watching and taking the time to leave a comment. -Sven

[@ChrisMears-w1w]

hey this is really useful, thanks so much. One question - will the stand alone exe file work when offline?

[@CodingIsFun]

Thanks for watching. Yes, it will also work without any internet connection. -Sven ✌️

[@RituAgarwal-u3h]

Would appreciate a tutorial of sign in and sign up page with streamlit

[@CodingIsFun]

Thank you for watching the video & your suggestion. Cheers, Sven ✌️

[@txreal2]

How is this better than MS Forms or Google Forms? Just curious. Thanks

[@barryvorster4696]

Thanks for this excellent video. Is it possible to package a Streamlit application using pyinstaller?

[@CodingIsFun]

Thanks for watching. Unfortunately, it is not that easy for Streamlit. If you want to convert a Streamlit app into an executable, check out the video from my KZbin friend Fanilo: kzbin.info/www/bejne/aai9aHqIl9dsZ8ksi=7zwqbeuqlObix3PY Good luck! 🍀 Cheers, Sven ✌️

[@truthseeker9988]

So how do we license this? Could you make a video explaining this?

[@CodingIsFun]

To license the GUI, you might consider establishing a database to validate license keys. Each time the GUI is launched or a button is clicked, the system could verify whether the entered license key exists in the database. If the key is invalid, an error message would be displayed. This is a basic framework for how it might work. I'm not certain if I'll create a tutorial on this topic, as it is quite specific, but thanks for you suggestion. Happy coding! Cheers, Sven ✌️

[@RituAgarwal-u3h]

Pls pls make a video on streamlit popups

[@CodingIsFun]

Thanks for watching and your suggestion. Cheers, Sven ✌️

[@rituagarwal8519]

Pls a tutorial of integrating streamlit with django

[@CodingIsFun]

Thanks for watching. Can you explain what exactly you would like to see? Thanks! Cheers, Sven ✌️

[@rituagarwal8519]

@@CodingIsFun thanks for reply actually according to chatgpt we can get full control to make complex UI by using Django and streamlit together

[@iDea16388-c]

Full course?

[@CodingIsFun]

What exactly do you mean? :)

[@luishernandezmatos2264]

Thanks, Make a video but now with a Machine learning model

[@MohamedMarzok-y8z]

wow , i paste the complete from before and chat GPT make updates with convenience changes , perfect , Chat GPT have inllegent AI that know i want to integrate the functionality of saving submissions to an Excel file, validating email addresses, and handling form submissions within the provided Tkinter GUI, chat GPT make automatic update the code and told me the missing things he will need to add it like : Add functionality to the existing Tkinter application to validate input. Save the data to submissions.xlsx with an auto-incremented ID. Clear fields and display success/error messages.

[@CodingIsFun]

Thanks for watching! -Sven ✌️

[@Copt774]

In figma it’s easier in my opinion to copy elements by selecting them and holding alt while dragging them.

[@CodingIsFun]

Cool! :)

[@arjaymoldez2736]

How to set the icon before converting it into exe file?

[@CodingIsFun]

Here you are: stackoverflow.com/a/33558141 Cheers, Sven ✌️

[@BrettBabione]

I created the gui.exe but Windows 11 thinks it is a virus and has quarantined it. Did this happen to anyone else?

[@BrettBabione]

It appears PyInstaller didn't finish properly. I got this error at the end: Operation did not complete successfully because the file contains a virus or potentially unwanted software.

[@BrettBabione]

I added the folder to the windows defender exclusions list and pyinstaller works fine now and I don't get a virus error. However, the exe that's created shows the form but does not create the xl file when I press submit.

[@BrettBabione]

I re-copied all of the code again and then re-saved the py file. I then ran PyInstaller again. Everything works fine now! The exe was created and it works!

[@CodingIsFun]

Yes, that also happened to me with Windows 11. I didn't mention it in this video, but I covered it in the previous one, including the solution, at this point: kzbin.info/www/bejne/hIezmpWMm6uJqq8si=EkeF3DusRx1rAYhS&t=617 Cheers, Sven ✌️

[@BrettBabione]

@@CodingIsFun Thank you. Great video. Very useful information.

[@dhruvansh5602]

When I run the python code, I can't see the img and names in tkinter GUI Does anyone know how to solve it?

[@CodingIsFun]

Thanks for watching. Please clone the repo and try again. Cheers, Sven ✌️

[@dhruvansh5602]

@@CodingIsFun Thanks admin, it really helped me. But I'm facing an error when i run the gui.exe file it is showing up "Failed to execute script 'gui' due to unhandled exception: No module named 'openpyxl'

[@CodingIsFun]

@@dhruvansh5602 Yepp, you need to install that package and include it when compiling it to an executable file, as shown in the video. Cheers, Sven and not admin

[@flordi8235]

this is not the following of the previous video! Why?You told that on the pr video will continue.... 😮

[@CodingIsFun]

What? Just because I used some different input fields?

[@confidential303]

Nice, but nowadays it feels like we all became more script kiddies then actual understanding what is going on :( .. don't meant to discourage you, it is great you give a solution on how to build if you don't have prior programming knowledge.

[@CodingIsFun]

You've raised a great point. I was actually quite hesitant to release this video. Initially, my plan was to code the functionality for saving data to Excel myself and share the thought process behind each decision. However, to be honest, my typical workflow for projects, whether in VBA or Python, is similar to what I demonstrated. I use ChatGPT to write code for me because it really speeds up my development process. I agree, it might not have been clear in the video, but I do check the code that ChatGPT generates. In the video, I simply executed the code without reviewing it first. The reason I still created the video, as you mentioned, is to show how little coding is actually needed to create an app like this, but I completely understand your criticism here. Cheers, Sven ✌️

[@confidential303]

@@CodingIsFun The problem is I like IT and programming it was quite a niche but it feels it gets more commodity like. It feels I cannot cope with it. I like to understand what I am doing. I refused to use ChatGPT because didn't want to become a script kiddie myself. But, a friend tipped me to use it but for a whole other reason and to my amazement I got hooked to it, just asking questions..it is a far more better than Google. Though, I was planning to build something in javascript..KZbin downloader..it just gave the code in javascript also in C# ..I havent tried it..but it can be a easy go solution without trying to figure out what topics to learn before I can write such code. The point is you can do a bit reverse engineering and try to understand the code. Though, what do you think, do we really need programmers now and in the future is it becoming obsolete ?

[@CodingIsFun]

@@confidential303 Currently, I view AI solutions as just another tool in my toolbox. I use these tools to build apps and solutions faster. However, you can't build anything too complex with just ChatGPT, like the Excel add-ins I enjoy creating. You still need to design your app's architecture, create the user interface, and break down the problems into smaller, manageable subproblems, which can then be tackled with the help of ChatGPT. This process is very similar to what I showed in the video. I knew I wanted to use openpyxl to work with Excel and had already clearly specified my requirements, such as validating the email before submitting, in my prompt. Regarding your question, I strongly suggest learning all the basics yourself and trying to build smaller apps on your own. Once you've mastered the basics, you can speed up your development with AI tools. As I mentioned, they're just tools in your toolbox. You definitely don't want to end up with a complete black box of code. And as I said in the video, if you don't understand what certain parts of the code are doing, you can still ask for explanations to see if it makes sense to you. I hope that helps a bit. Happy learning and coding!

[@confidential303]

@@CodingIsFun Thank you for your advice. The problem is there is too many tutorials and there are too many things I want to learn. I feel like I am unorganized wanting to learn everything but not making real efforts into doing it only maybe watching youtube clips which seems promising but ending up doing nothing. Think it is also prioritizing what to learn first and making an schedule. For instance I see tutorials almost 8 hours from codecamp..that is too daunting for me.