In this tutorial, I'm going to walk you through the process of creating a GUI app with Python. I'll show you how to create an advanced Graphical User Interface complete with buttons, input boxes, user settings and a custom menu bar. I'll start with a simple GUI app that has just two buttons. Then, we'll create a more advanced GUI app to retrieve and save user settings. Finally, we will implement a custom menu bar and convert our code into a standalone executable file.
In the final application, you can convert a selected Excel sheet into a CSV file. Additionally, you could specify the separator & decimal value for the CSV file.
- Load/Save user settings
- Custom Toolbar
- Convert Excel Files to CSV
Install the dependecies with pip
openpyxl==3.0.10
pandas==1.3.5
PySimpleGUI==4.60.1
# [Vanilla Terminal] Run the application
python main.py
I've developed some handy Excel add-ins that you might find useful:
- 📊 Dashboard Add-in: Easily create interactive and visually appealing dashboards.
- 🎨 Cartoon Charts Add-In: Create engaging and fun cartoon-style charts.
- 🤪 Emoji Add-in: Add a touch of fun to your spreadsheets with emojis.
- 🛠️ MyToolBelt Add-in: A versatile toolbelt for Excel, featuring:
- Creation of Pandas DataFrames and Jupyter Notebooks from Excel ranges
- ChatGPT integration for advanced data analysis
- And much more!
- 📺 YouTube: CodingIsFun
- 🌐 Website: PythonAndVBA
- 💬 Discord: Join our Community
- 💼 LinkedIn: Connect with me
- 📸 Instagram: Follow me
Love my content and want to show appreciation? Why not buy me a coffee to fuel my creative engine? Your support means the world to me! 😊
Got some thoughts or suggestions? Don't hesitate to reach out to me at contact@pythonandvba.com. I'd love to hear from you! 💡