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