Binding functions to buttons created in a loop in tkinter

Question

I wrote a for loop to create buttons according to the number of sheets in an excel workbook. However, I'm having a hard time binding functions that print the data on each sheet. Can anyone help? Thanks. Here's what I have done

wb = xlrd.open_workbook('file_path.xlsx')
        sheetnames = wb.sheet_names()
        num_sheets = len(sheetnames)

        def load_sheet():
        for d in range(0, num_sheets):
            print(sheetnames[d])

        for i in range(0, num_sheets):
            an_sheet = ttk.Button(self, text = "%s" % sheetnames[i], 
                                  command= lambda : load_data)
            an_sheet.grid(row = 1, column = i+1, sticky='w', pady = 10, padx = 10)

sorry forgot to paste that piece of the code .. editing question asap — Samuel Adafia
– Samuel Adafia, Commented Mar 21, 2017 at 17:22

Novel · Accepted Answer · 2017-03-21 17:24:02Z

1

It's a common beginner's issue if you are using lambda in a for loop because beginners don't realize that lambda is late-binding. In other words it always uses the last value of "i", not the value of "i" when the command argument was set. In this case you need to use functools.partial instead:

from functools import partial
# ...
for i in range(0, num_sheets):
    an_sheet = ttk.Button(self, text = "%s" % sheetnames[i], command=partial(function, i))
    an_sheet.grid(row = 1, column = i+1, sticky='w', pady = 10, padx = 10)

answered Mar 21, 2017 at 17:24

Novel

13.7k2 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Samuel Adafia Over a year ago

Thank you very much, does functools come with python or i have to install it.

Novel Over a year ago

It's part of the default install.

Collectives™ on Stack Overflow

Binding functions to buttons created in a loop in tkinter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related