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

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My RU-vid Channel: bit.ly/2UFLKgj bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN ▶️ Get The Code bit.ly/3fLFQ8p

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

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

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!

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

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

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

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

Thank You for the video. ❤❤❤

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

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

Great video. Very informative and well explained

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?

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

thank you Mr Elder for this cool contents 👍

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

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 .

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")

Is it possible to open only selected columns from a spreadsheet instead of the entire sheet?

I did everything but it gives me the error "file not found". Maybe something is missing between the lines "filename = ..." and "pd.read_excel()..." ?

NIce i have been watchin all ur vids recently

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

Thanks !! the video is perfect !

awesome!!!

Hey, is it possible to group data be a particular column and then display it? Fir example if multiple records have the the same value of one column, say the "Name" column, is it possible to add the first one to a parent and create a child which contains the rest of the data?

Is it possible to show up specific rows and columns from a DataFrame on the Treeview? Hoping you can give me a hand?

Is it possible to click on a record in Tree-View and clicking on it automatically fills in all the data from that record in the corresponding entry boxes available on the screen?

Sir, how can I align the values ​​in the center of the column?

I get " NameError: name ´df´ is not defined" in: my_tree["column"] = list(df.columns) what could be the reason?

The Tkinter textbox i doing some weird stuff, whenever I m working with the text widget and press (Control+i, Control+h, Control+k), it start doing weird stuff like:- Control+i - is deleting all the selected text (the text under selection tag). Control+h - is working somewhat like a Backspace key. Control-k - removes all the text at the right side to the position of cursor. Do you know some trick to fix that? Like it's messing up the things if i wanna bind some event or function with these key combinations, like I wanna use Control-Key-I for Italics function

John, is it possible to do a delete columns function that works with the spreadsheet we see in the Treeview ?

Thanks a lot man

Gracias señor

thanks... however, pyinstaller is having issues with pandas.

Great.

Hi Teacher, Am John from Kenya. Kindly create a video on how to print tkinter treeview data. Am trying it but it's printing blank page. Thanks.

Yeah, I'm struggling with this. I copied your direct code from Github and amended the initial directory and deleted the icon line. I'm given the Value Error message from the Exception handling code that was entered. And this (I shortened the file directories): Exception in Tkinter callback Traceback (most recent call last): File "C:\...\Python39\lib\tkinter\__init__.py", line 1892, in __call__ return self.func(*args) File "C:\...\File.py", line 36, in file_open my_tree["column"] = list(df.columns) UnboundLocalError: local variable 'df' referenced before assignment I'd love to get this working. Any ideas? Cheers

Thank you for the tutorial. One thing that bothered me was the .filetype command. I tkinter is using .filetypes in the current version instead.

sorry sir, i can't know it my_tree["column"] = list(df.columns) Unbound Local Error: local variable 'df' referenced before assignment

sir CSV file is not opening with it

There are not shown more than 1600 rows in treeview table. Need to show more than 5000 rows. pls make a tutorial in this regard.

Great video John. Could you possibly do a video regarding taking an sql database and slapping it onto a treeview?

How to add search field in this, which works dynamically filtered with data ? Thanks in advance

Way to open a file? I just use the string returned from filedialog, rather than converting it to a string.

Sir, I want to ask that can we convert .py file to .apk file or not?

how should fix this error >>>> ModuleNotFoundError: No module named '_typeshed'

Hello Sir, I tried this code but the filemenu was not added somehow so i cannot see the menu to open the file also there is no error i cannot understand what should i do

It is possible with csv file ?

Sir how do we fix the width in the case of importing excel file?

Hello sir, I have an question about django related quries sir "how to insert multiple images in carousal using django" i request you plz give me an answer its very important

how to Open Exel Spreadsheet in Grid ?

Sir can you please make a video to add scrollbars to browse excel file in tree view.

Traceback (most recent call last): File "c:\Users\MAA\OneDrive\Desktop\WaySoul\pract.py", line 148, in file_menu.add_command(Lable="Open",command=file_open) File "C:\Users\MAA\AppData\Local\Programs\Python\Python39\lib\tkinter\__init__.py", line 3302, in add_command self.add('command', cnf or kw) File "C:\Users\MAA\AppData\Local\Programs\Python\Python39\lib\tkinter\__init__.py", line 3289, in add self.tk.call((self._w, 'add', itemType) + _tkinter.TclError: unknown option "-Lable"

No big boooom today😔