In this video I’ll show you how to pull entire columns of data from a .xlsx Excel spreadsheet file and display it in a TKinter ListBox widget using openpyxl.
Openpyxl makes it really easy to grab columns of data from an Excel spreadsheet. Then we’ll loop through that data and insert it into a Listbox.
We’ll also create a binding on the listbox that allows us to click on an item in the list box and output that item onto a Label.
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