Open Excel Spreadsheet In Treeview With Pandas and Numpy - Python Tkinter GUI Tutorial #125

In this video we'll import spreadsheet data from an Excel .xlsx file to our Treeview in Tkinter with Python.

To pull data from Excel, we're going to use Pandas and Numpy to do most of the heavy lifting. You don't need to know anything about Pandas or Numpy in order to do this, we'll pip install them and I'll show you everything you need.

We'll also use a Tkinter Filedialog box to select the excel file we want to open. Then our Treeview will be updated automatically.

[Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:
▶️ Get The Code

[ProgrammingTechStudent]

Your Python Tkinter Playlist is really helping the students and I'm one of them 😅😅😅
Thanks a lot Sir !

[pascalkop]

Greetings from the Netherlands in the EU (capital Amsterdam 👊🏻)
Thank you so much for explaining everything.
I really learn a lot from your YouTube channel.

[christoskarliampas]

It is in fact a series everyone interested in Python and Tkinter should follow, I found it very informative! Thank you so much, you helped me a lot to start programming my first GUI!

[AruviTechNews]

Explaining the each and every line of program clearly..Thank you so much Sir...

[aavalos]

Great tutorial. I actually applied this to my vehicle inventory query app and added vertical and horizontal scrollbars. Thank you.

[muneebkhan]

I'm making a POS software and your videos are helping me a lot.

[RyanDanielG]

Smash that like button guys n gals! its free! great python tkinter tutorial, Codemy. Thanks

[YK-fdhf]

Thank you SO MUCH for this tutorial, I have been looking for one of these for a while now

[andreboss]

Great video. Very informative and well explained

[shreyashprakash]

NIce i have been watchin all ur vids recently

[alialavizadeh]

thank you Mr Elder for this cool contents 👍

[ajsunofficial]

John how about not opening the file..but we have a dialogue box and we give them a word or code and it reads thru a folder with multiple pdfs and brings it back in on the screen relevant information say a line or two of the word or the code

[krishnanandshenoy]

Thanks you sir for this amazing tutorials ...helped me a lot in my project 🙏

[fernandomartino]

is there a way to automatically adjust the column width depending on the width of the text in the columns? How could be done this?

[MaryjoyFreires]

Hi sir, how about open a specific sheet for example is I only want to show to my treeview the sheet 2 in excel?

[ikrameounadi]

HELPP PLEASE !!!! i'm working on a project, the main page has upload button and search button, i uploaded the file like you did in the command of the upload button so when i press the button i get a new window with this video content, but when i close it the data is not saved, i want to use the search button to get information from the excel file uploaded in the content of the upload button . MY problem is i don't know how to save the data when i close the window, and how to make the search .

[AmandaSalisbury-ibfw]

My except error code is not being run after an exception. If I run file_open(): I get the open file window, but if I close it without choosing a file I get the FileNotFoundError. Then my program freezes up and I can no longer open a file due to locked database. It never executes what is inside the except error code. Added the print to see if there was something wrong with my label, and it never showed up. I also added text to the label where it was created and it did show up.

if filename:
try:
filename = r"{}".format(filename)
df = pd.read_excel(filename, header= None)

except FileNotFoundError:
print('Did This Work?')
my_label.config(text="File could not be Opened")

except ValueError:
my_label.config(text="File could not be Opened")

[sathyabhat]

Can anyone tell me how to keep this treeview window dynamic!!

For Ex : If the content changes in .CSV file, it should automatically update in treeview window..

Please guide

[aceofspades]

I did everything but it gives me the error "file not found".

Maybe something is missing between the lines "filename = ..." and "pd.read_excel()..." ?