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!
Works for csv's too, just need to swap out some of the File_dialogue filetype params or can feed it a list of pandas acceptable types to make it more generic.
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.
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 UA-cam journey.
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)
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.
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!
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 ?
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 :) :) :)
Thanks Abhishek, I've created a tutorial recently that kind of extends on this script. It allows you to drag and drop csv files directly into the GUI. Which works better than a drop down in my option because a drop down would have to be hard coded i believe.
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
You'll need to do some modification. Took me about an hour to figure it out, but works great now with csv, txt, and xlsx file extensions. Use the If file_path.split(".")[-1] == "csv": statement (same for .txt extension) and make the assignments in the load_file function conditional. Good luck!
Quick questions are you using the code in the video or the code in the github gist in the description? are you trying to load an excel file? if you are trying to load an excel file the code in the github gist should work. I missed out a few lines in this video that would enable it to work on excel files. therefore the code on this video only works on csv
This is actually quite easy to do. You can store the dataframe in memory each time is it loaded and have a button that plots the data based on an x and y variable you set
Hi Minki, Yes this can definitely be done. I have only done this for a Treeview though. In my latest video "How to Bind to Widgets in Tkinter (Python GUI)" I show exactly how you can go about achieving this
Hi Plaine, You could remove the file dialog function and the "Browse a file" button. and then you could either make label or filepath variable (inside the load excel data function) equal to the path of your specific file
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
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?
No problem Yannick, a few questions i have. What version of python are you using? Python 3 right? Are you getting the error as soon as you run the script or is it occuring when an excel file has already been loaded? I copied and pasted the source code myself and it worked fine. The error you have seems to occur when a widget is called after it has been destroyed and the only thing that destroyed here is the children of the treeview
Hi - just seen no one has replied! I've just done a project that required data to be loaded in by the user. I used the filedialog module tkinter to get the file paths and then stored those in a variable. I then read the file in through pandas and stored it within the program as a dataframe. Hope that helps - I'm afraid I can't give exact code snippets because they're for a university assignment.
If you tried to read in a csv file you would've got that error as i forgot to account for csv files in this videos code. However the code in the GitHub Gist in the description works for csv files.
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!
Works for csv's too, just need to swap out some of the File_dialogue filetype params or can feed it a list of pandas acceptable types to make it more generic.
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.
much appreciated, just trying to help educate and save people some time :)
A great video illustrating a practical implementation around a Treeview. 👍
'You're waking up in 7 hours' lmaooo that hit different 😂😂
Very educational. I modified it for accepting csv and txt files as well.
how did you do ? can i get the code please
This was unbelievably helpful
You're a life saver. Cheers.
no problem
This was extremely helpful. Thanks for this video.
Congratulations, you are the best!
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
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 UA-cam journey.
Thanks, looking back on this video i could've easily reduced it.
I want to thanks for this clean explanation ... 🇩🇿👍
you saved my life. thank you very much !
You're welcome!
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)
Nice, clear and simple thx
You are a life saver Jezz
no problem
Awesome , really well explained!
Glad it was helpful!
how to perform search opration on selected excel file plz make video on this topic
I will try to create a tutorial for that next week
Thank you so much..You saved me
Happy to help
Great tutorial. Thank you for keeping it simple. How about showing how to alter the df frame and return as excel file
Good information
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.
can we highlight rows in yellow color based on a condition in tkinter console ?
thanks helped me much!
nice! ... now how do you move items up, delete them, and insert new ones somewhere between two rows...
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 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!
Big thanks to you
how I can create GUI for search box or search engine to the dataset by using python?
I know this request is old but i will try to create a tutorial this week showing this
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 ?
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 :) :) :)
Thanks Abhishek,
I've created a tutorial recently that kind of extends on this script. It allows you to drag and drop csv files directly into the GUI. Which works better than a drop down in my option because a drop down would have to be hard coded i believe.
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?
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
can this works with csv files?
You'll need to do some modification. Took me about an hour to figure it out, but works great now with csv, txt, and xlsx file extensions. Use the
If file_path.split(".")[-1] == "csv":
statement (same for .txt extension) and make the assignments in the load_file function conditional.
Good luck!
Hi.
Thanks for the tutorial.
I got a problem with the attribute yview and xview for treescrolly and treescrollx.
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?
Quick questions are you using the code in the video or the code in the github gist in the description? are you trying to load an excel file?
if you are trying to load an excel file the code in the github gist should work. I missed out a few lines in this video that would enable it to work on excel files. therefore the code on this video only works on csv
@@RamonWilliams 😢
Can you please extend this program to plot a graph using the loaded excel file
This is actually quite easy to do. You can store the dataframe in memory each time is it loaded and have a button that plots the data based on an x and y variable you set
If excel data cells have hyperlink, can we bring them into listbox and they can be clickable?
Hi Minki,
Yes this can definitely be done. I have only done this for a Treeview though. In my latest video "How to Bind to Widgets in Tkinter (Python GUI)" I show exactly how you can go about achieving this
very nice!
How can I edit the code so that it always opens a specific file of my choice
Hi Plaine,
You could remove the file dialog function and the "Browse a file" button. and then you could either make label or filepath variable (inside the load excel data function) equal to the path of your specific file
@@RamonWilliams Thank you
👍👍👍 Jesus christ u r awesome.thanks.
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
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?
did you change the source in any way?
No problem Yannick, a few questions i have.
What version of python are you using? Python 3 right?
Are you getting the error as soon as you run the script or is it occuring when an excel file has already been loaded?
I copied and pasted the source code myself and it worked fine.
The error you have seems to occur when a widget is called after it has been destroyed and the only thing that destroyed here is the children of the treeview
Hi，Could I just use tkinter load file data to python?
Hi - just seen no one has replied! I've just done a project that required data to be loaded in by the user. I used the filedialog module tkinter to get the file paths and then stored those in a variable. I then read the file in through pandas and stored it within the program as a dataframe. Hope that helps - I'm afraid I can't give exact code snippets because they're for a university assignment.
how can I solve error like
"unsupported format : Expected BOF record"
If you tried to read in a csv file you would've got that error as i forgot to account for csv files in this videos code. However the code in the GitHub Gist in the description works for csv files.
help somebody please, i got an error: 'Index' object is not callable