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 Elder

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

Add comment

Your email address will not be published. Required fields are marked *

John Elder

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...