body {
font-family: Arial, sans-serif;
line-height: 1.6;
margin: 40px;
padding: 0;
}
h1 {
text-align: center;
}
p {
margin-bottom: 20px;
}
Python Excel App – Excel Viewer & Data Entry Form
If you are looking for a Python GUI project that involves working with Excel files, then the Python Excel App – Excel Viewer & Data Entry Form is a great choice. This project uses the Tkinter library for building the GUI and the openpyxl library for handling Excel files.
With this application, users can view and interact with Excel files in a user-friendly way. It provides a convenient interface for browsing through the contents of an Excel file, as well as a data entry form for adding or modifying data in the file.
The Tkinter library is a standard GUI toolkit for Python and provides a simple way to create graphical user interfaces. With Tkinter, developers can create windows, buttons, textboxes, and other GUI components to build a user-friendly application.
On the other hand, the openpyxl library allows Python developers to read and write Excel files. It provides advanced features for working with Excel spreadsheets, such as creating new files, modifying existing ones, and extracting data from them.
Combining Tkinter and openpyxl, the Python Excel App – Excel Viewer & Data Entry Form project offers a seamless experience for users who want to work with Excel files without leaving the Python environment. This can be particularly useful for businesses or organizations that rely heavily on Excel for data management and analysis.
Overall, this Python GUI project is a practical and valuable tool for anyone who needs to work with Excel files using Python. It is a great example of how Python can be used to create powerful and user-friendly applications for data manipulation and visualization.
hi how did u get the treeview theme ? is there a style cript or something ?
Great video Hala! keep it up
Thank you very much!
I don't know Python but what are you showing is awesome, keep moving!!!!!!!!
She is super amazing.
Thank you for this tutorial. Your explanations are very clear. I can follow along without getting lost. Now I understand better how to build Python code with tkinter. Thank you, Hala!
excellent presentation and very clear mind
When I use openpyxl multiple times it slows down my excel sheet massively. Why is that?
The way she explains the code and what it is used for as she goes along is a lesson other youtubers could learn.
I've got an idea after watching this video. I'm going to unwillingly share it with you and I hope you will not steal my idea before I get to patent it. Basically what I've invented is to use a simple excel-sheet as a database without having excel on the computer. Then I can store stuff in the rows and make a gui similar to the one shown in the video. Feel free to borrow my idea until I start selling licenses to use this idea, Off course, when I get the patent rights for it I'll bill you a small fee for using my invention.
@Code First with Hala, nice video, please say: how to edit and values at the treeview??? thank you
If you are getting the error:
root.tk.call("source", "forest-light.tcl")
_tkinter.TclError: no files matched glob pattern "*.png"
Then please make sure that you have also imported the folder forest-dark and forest-light from the original rest-ttk-theme repo. Didn't realise Hala version did not have those files.
So make sure that the folders are in the same directory as the place where you have cloned Hala's repo.
Nice, thank you!
Thank you so much for your tutorial… lots of love ❤from India
I love you so much ❤
Where can I find a prof as smart as you 👏🏽
please how to get the git folder ????
I was wondering how to change the value in the GUI from Employed to Unemployed as the checkbox is toggled. Do you have a video about that?
Thank YOU and chokran HALA
Getting Error @ the following step: root.tk.call("source", "Forest-light.tcl"). Error received: Exception has occurred: TclError
no files matched glob pattern "*.png"
File "C:Users…….Employee Info.py", line 7, in <module>
root.tk.call("source", "Forest-light.tcl")
_tkinter.TclError: no files matched glob pattern "*.png"