How to view Excel File or Pandas DataFrame in Tkinter (Python GUI) 

Timestamps 0:00 Intro 1:00 Creating the Root, Frames, Label and Buttons 10:00 Creating the Treeview Widget and scrollbars 14:44 Creating the button commands 16:53 Creating the File Dialog Function (opens file explorer) 19:40 Load Excel File into Treeview (what you most likely came for) 25:54 Testing the code It's probably evident but i didn't check beforehand if it works for csv files. Nevertheless for the code please see the description, the code in the description also works for csv files!

Don't leave comments very often but just saying nice one bro, exactly what I was looking for anyway! Nice to have actual explanations behind some of the functionality and parameter sets for a change.

'You're waking up in 7 hours' lmaooo that hit different 😂😂

A great video illustrating a practical implementation around a Treeview. 👍

Very educational. I modified it for accepting csv and txt files as well.

Excellent tutorial, thanks much. Still trying to figure out how to control the column widths otherwise it is all working great. Got it, in the column loop add tv1.column(column, width= 350)

and now do a video about how to edit those values or add new values or delete values and automatically save it. It will help a lot

This was unbelievably helpful

This was extremely helpful. Thanks for this video.

You're a life saver. Cheers.

Congratulations, you are the best!

I want to thanks for this clean explanation ... 🇩🇿👍

Great tutorial. Thank you for keeping it simple. How about showing how to alter the df frame and return as excel file

Thanks Ramson....I like your explanations also but i think if can reduce video length less than 7:59 minutes it will help you to increase your subscribers. Try to create tutorial videos. All the best for your RU-vid journey.

you saved my life. thank you very much !

Awesome , really well explained!

This was great, thank you. I was actually looking for a video that would show me how to allow a user to select an excel file and then have my program run pandas stuff on it and then return a new dataframe (that was modified as per the pandas stuff) and then save it wherever the user wanted to save it as an excel file. Do you have any content like that? Thank you.

Nice, clear and simple thx

You are a life saver Jezz

Thank you so much..You saved me

Good information

nice! ... now how do you move items up, delete them, and insert new ones somewhere between two rows...

Thanks Buddy for this awesome script :) Can you please add functionality in which user can select some format or style from drop down & fetch an excel report. But Nice Script Awesome :) :) :)

how to perform search opration on selected excel file plz make video on this topic

This code helped me a lot. I just wanted to ask, how do I get rid of an additional "unnamed" column without hard coding it?

Thank you for the tutorials. Please how do i create a filter dataframe from the load excel data and have it displayed on another window

thanks helped me much!

Thanks a lot for this! Very helpful. I have one question, how can I work with loaded excel/csv file, for example if I want to get the values from it and use them for any calculations? Even a little hint will help, thank you!

I am getting some errors. No such file as (file_path) when i click load, so the try/except isnt working and the browse does not work probablt because of the initialdir. i didnt see this on yout github but ill look again

Hi. Thanks for the tutorial. I got a problem with the attribute yview and xview for treescrolly and treescrollx.

how I can create GUI for search box or search engine to the dataset by using python?

Hi Ramon Williams, Thanks a lot for this! Very helpful. I want to open multiple excel files and plot them. Tried to add some code but it didn't work. Can you help me please ?

Big thanks to you

Great Explanation. But, when i try the treeview widget i receive an error stating "NULL main window". Copied your code from "Github". Can you help on this. TIA

very nice!

hi Ramon, im using gspread/pandas/numpy module and want to load a specific google sheet into a tkinter window, ive got it all working fine without tkinter/gui, any help would be dearly appreciated as ive been struggling on this for some weeks now as im a newbie python coder. best regards simon. also really enjoyed your tut and subbed.

help somebody please, i got an error: 'Index' object is not callable

can this works with csv files?

If excel data cells have hyperlink, can we bring them into listbox and they can be clickable?

Can you please extend this program to plot a graph using the loaded excel file

how can I solve error like "unsupported format : Expected BOF record"

👍👍👍 Jesus christ u r awesome.thanks.

Thank you so much. But whenever I load the excel / csv file it shows me "The file you selected is not valid." Why is that. How can I fix it?

I have copied the source code on github and ran it. I have a problem with tv.configure line it brings the following : invalid command name ".!labelframe.!treeview". Can you tell me what to do, please? Thanks for this video?

How can I edit the code so that it always opens a specific file of my choice

Hi，Could I just use tkinter load file data to python?