/advanced-gui-with-usersettings-and-menubar

PySimpleGUI application with menu bar & settings (.ini) file to load/save user settings

Primary LanguagePython

Create an advanced GUI app with PySimpleGUI (Full Tutorial)

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.

Features

  • Load/Save user settings
  • Custom Toolbar
  • Convert Excel Files to CSV

Screenshots

Main Window: Main Window
Settings Window: Settings Window

Video Tutorial

YouTube Video

Requirements

Install the dependecies with pip

openpyxl==3.0.10
pandas==1.3.5
PySimpleGUI==4.60.1

Usage

# [Vanilla Terminal] Run the application
python main.py

🤓 Check Out My Excel Add-ins

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!

🤝 Connect with Me

Support My Work

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! 😊

ko-fi

Feedback

Got some thoughts or suggestions? Don't hesitate to reach out to me at contact@pythonandvba.com. I'd love to hear from you! 💡 Logo