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.
John is the CEO of Codemy.com where he teaches over 100,000 students how to code! He founded one of the Internet's earliest advertising networks and sold it to a publicly company at the height of the first dot com boom. After that he developed the award-winning Submission-Spider search engine submission software that's been used by over 3 million individuals, businesses, and governments in over 42 countries. He's written several Amazon #1 best selling books on coding, and runs a popular Youtube coding channel.
View all posts
John is the CEO of Codemy.com where he teaches over 100,000 students how to code! He founded one of the Internet's earliest advertising networks and sold it to a publicly company at the height of...
Add comment