Skip to main content
 首页 » 编程设计

python之tkinter 中的循环按钮和功能分配

2025年02月15日7EasonJim

我已经能够使用这段代码在 tkinter 中生成按钮

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

现在这些按钮是根据 Excel 工作表中的工作表数量生成的,并且还分配了它们所代表的工作表的名称。但是,有一个函数可以打印所代表的每张纸的内容。

def load_sheets(): 
            for i,sheetname in enumerate(sh_names) : 
                xl_sheet = wb.sheet_by_name(sh_names[i]) 
                print() 
                print(sheetname) 
                row = xl_sheet.row(0)    
                for idx, cell_obj in enumerate(row): 
                    cell_type_str = ctype_text.get(cell_obj.ctype, 'unknown type') 
 
                row = xl_sheet.nrows 
                for col_idx in range(0, xl_sheet.ncols): 
                    print ('Column: %s' % col_idx) 
                    for row_idx in range(0, row): 
                        cell_obj = xl_sheet.cell(row_idx, col_idx) 
                        print ('Row: [%s] cell_obj: [%s]' % (row_idx, cell_obj)) 

现在的挑战是将函数绑定(bind)到按钮,以便在单击按钮时打印出自己的内容。例如,单击名为“工作表 1”的按钮时,应打印工作表 1 的内容。

这是代码的完整结构。

class MainMenu(tk.Frame): 
 
    def __init__(self, parent, controller): 
        tk.Frame.__init__(self, parent) 
 
 
        fname = join(dirname(dirname(abspath('C:/Users/qanda/OneDrive/Documents/Python Scripts/PEN'))), 'Python Scripts/PEN', 'Book1.xlsx')    
        wb = xlrd.open_workbook(fname) 
        sh_names = wb.sheet_names() 
        num_sheets = len(sh_names) 
 
        def load_sheets(): 
            for i,sheetname in enumerate(sh_names) : 
                xl_sheet = wb.sheet_by_name(sh_names[i]) 
                print() 
                print(sheetname) 
                row = xl_sheet.row(0)    
                for idx, cell_obj in enumerate(row): 
                    cell_type_str = ctype_text.get(cell_obj.ctype, 'unknown type') 
 
                row = xl_sheet.nrows 
                for col_idx in range(0, xl_sheet.ncols): 
                    print ('Column: %s' % col_idx) 
                    for row_idx in range(0, row): 
                        cell_obj = xl_sheet.cell(row_idx, col_idx) 
                        print ('Row: [%s] cell_obj: [%s]' % (row_idx, cell_obj)) 
 
 
        for i in range(0, num_sheets): 
            an_sheet = ttk.Button(self, text = "%s" % sh_names[i], command = partial(load_sheets)) 
            an_sheet.grid(row = 1, column = i+1, sticky='w', pady = 10, padx = 10) 

请您参考如下方法:

定义一个函数来打印一张纸的内容,将纸编号作为参数。然后,使用 functools.partial 将命令与每个按钮相关联:

def print_sheet(sheet_number): 
    ... 
 
for i in range(0, num_sheets): 
    an_sheet = ttk.Button(..., command = partial(print_sheet, i)) 
    ... 

这是一个在循环中创建按钮的简短但完整的示例:

import tkinter as tk 
from tkinter import ttk 
from functools import partial 
 
root = tk.Tk() 
 
def print_sheet(i): 
    print("printing sheet %d" % i) 
 
for i in range(0, 5): 
    button = ttk.Button(root, text="Button %d" % i, 
                        command=partial(print_sheet, i)) 
    button.pack() 
 
root.mainloop()