Python Excel App - Excel Viewer & Data Entry Form [Tkinter, openpyxl] Python GUI Project

Опубликовано: 11 Февраль 2025
на канале: Code First with Hala

178,068

4.4k

Build a modern Tkinter GUI project to automate Excel tasks with Python. This Python GUI project works as both a data entry form and an Excel viewer.

In this video, you will:
Create your first Tkinter application
Create a modern Tkinter app
Use a Tkinter theme with ttk
Create a Tkinter data entry form
Use the Tkinter Button, ComboBox, Spinbox, Entry, CheckButton
Style and modify Tkinter widgets
Use both a dark and a light mode for the app
Install openpyxl
Load data from Excel into Python
Use data entry form to add data into Excel

Theme Github repo: https://github.com/rdbende/Forest-ttk...
Source code repo: https://github.com/codefirstio/tkinte...

Timestamps:
00:00 Introduction and Overview
01:05 Forest-ttk Theme Overview
01:58 Project folder structure
03:13 Starter code
04:44 Using the theme
05:40 Understanding Tkinter geometry managers
10:16 Creating the Name entry
15:36 Creating the Age spinbox
17:56 Creating the Subscription Status combobox
20:44 Creating the Employment Status checkbutton
22:58 Creating the Insert button
23:34 Updating the padding of the widgets
25:19 Creating the separator
26:15 Creating the Mode switch
27:17 Changing between dark mode and light mode
29:34 Creating the Treeview to display the Excel data
34:21 Installing openpyxl
35:27 Loading data from Excel into the treeview
39:28 Collecting the data from the Insert Row form
42:52 Inserting the data into the Excel sheet and treeview
45:12 Clearing the form after inserting

Socials:
My email: [email protected]
Tiktok: / hala.codes

*************
*Tags*
Tkinter tutorial
Tkinter Data Entry
Data Entry form Tkinter
Tkinter install
Tkinter Setup
Tkinter GUI tutorial
GUI tutorial Python
GUI Project Python
Graphical User Interface Python
Python tutorial
openpyxl
openpyxl tutorial
learn openpyxl