如何将Combobox与Radiobutton绑定并实现级联Combobox功能？

Hey there! Let's get your tkinter app working properly. I'll walk through the issues in your code, fix them, and show you how to set up that cascading Combobox you're planning.

Key Issues in Your Current Code #

• Variable Scope Mix-Up: You declared a global df_MA, but inside set_department you created a local variable with the same name—so the global one never gets updated. Using class instance variables (like self.df_MA) is cleaner for tkinter apps.
• Combobox Doesn't Refresh: Even if you fetched the user list, you never told the Combobox to update its options. You need to explicitly set its values property after loading the data.
• Function Placement: Nesting functions inside __init__ works, but moving them to be class methods makes your code more organized and easier to debug.
• Unnecessary Lambda: You don't need a lambda for the Radiobutton command—you can directly call a class method, which can access the selected department via the instance variable.

Fixed Code with Explanations #

import tkinter as tk
from tkinter import ttk
import pandas as pd
import os

class Window(tk.Toplevel):
    def __init__(self, parent):
        super().__init__(parent)
        self.geometry('300x100')
        self.title('Toplevel Window')
        ttk.Button(self, text='Close', command=self.destroy).pack(expand=True)

class App(tk.Tk):
    def __init__(self, *args, **kwargs):
        super().__init__()
        self.geometry('500x600')
        border = 10
        spacey = 10

        # Paths for input files (store as instance variables if you need them elsewhere)
        self.path_input_produktion = os.path.abspath('input_data\\werte_comboboxen_produktion.xlsx')
        self.path_input_service = os.path.abspath('input_data\\werte_comboboxen_service.xlsx')

        # Variable for selected department (instance variable so methods can access it)
        self.department = tk.StringVar(value=" ")

        # Initialize instance variable for user list
        self.df_MA = []

        # Create and place department Radiobuttons
        self._create_department_frame()

        # Create and place user Combobox
        self._create_user_combobox()

    def _create_department_frame(self):
        """Helper method to create the Radiobutton frame"""
        self.rb_frame_abteilung = tk.Frame(self)
        
        rb_abteilung_produktion = tk.Radiobutton(
            self.rb_frame_abteilung, 
            text="Produktion", 
            variable=self.department, 
            value="produktion", 
            command=self.set_department  # Directly call the class method
        )
        rb_abteilung_service = tk.Radiobutton(
            self.rb_frame_abteilung, 
            text="Service", 
            variable=self.department, 
            value="service", 
            command=self.set_department
        )

        rb_abteilung_produktion.pack(side="left", fill=None, expand=False, padx=10)
        rb_abteilung_service.pack(side="left", fill=None, expand=False, padx=10)
        self.rb_frame_abteilung.grid(row=5, column=1, sticky="nw", columnspan=99)

    def _create_user_combobox(self):
        """Helper method to create the user Combobox"""
        ttk.Label(self, text='user').grid(row=15, column=15, pady=spacey, padx=border, sticky='w')
        
        self.combobox_user = ttk.Combobox(self, width=10, value=self.df_MA)
        # Bind selection event to the method that will handle cascading
        self.combobox_user.bind("<<ComboboxSelected>>", self.on_user_selected)
        self.combobox_user.grid(row=15, column=20, pady=spacey, sticky='w')

    def set_department(self):
        """Load user list based on selected department and update Combobox"""
        selected_dept = self.department.get()
        if not selected_dept or selected_dept == " ":
            return  # Do nothing if no department is selected

        # Pick the correct file path
        if selected_dept == "produktion":
            file_path = self.path_input_produktion
        elif selected_dept == "service":
            file_path = self.path_input_service
        else:
            return

        # Load the Excel file and extract the MA column
        working_df_complete = pd.read_excel(file_path)
        self.df_MA = working_df_complete['MA'].tolist()  # Update instance variable

        # Update the Combobox with the new user list
        self.combobox_user['values'] = self.df_MA
        # Optional: Clear any previous selection
        self.combobox_user.set('')

    def on_user_selected(self, event):
        """Handle selection in user Combobox for cascading functionality"""
        selected_user = self.combobox_user.get()
        if not selected_user:
            return

        # Here's where you'll load working steps based on selected_user
        # Example:
        # working_steps = self._get_working_steps_for_user(selected_user)
        # self.combobox_working_steps['values'] = working_steps
        print(f"Selected user: {selected_user}")

        # For your cascading Combobox, you'd create a second Combobox in __init__
        # and update its values here, similar to how we updated the user Combobox

if __name__ == "__main__":
    app = App()
    app.mainloop()

What Changed? #

1. Instance Variables: Replaced global df_MA and department variable with self.df_MA and self.department so all methods can access them.
2. Organized Methods: Split UI creation into helper methods (_create_department_frame, _create_user_combobox) to keep __init__ clean.
3. Combobox Update: Added self.combobox_user['values'] = self.df_MA in set_department to refresh the dropdown options when a department is selected.
4. Removed Unnecessary Lambda: The Radiobuttons now directly call self.set_department, which uses self.department.get() to get the selected value.
5. Cascading Setup: The on_user_selected method is ready for you to add code that loads working steps based on the selected user and updates a second Combobox.

Adding the Cascading Combobox #

To add a second Combobox that depends on the user selection:

1. Add a new instance variable for working steps (e.g., self.working_steps = []) in __init__.
2. Create a second Combobox in _create_user_combobox (or a new helper method) similar to the user Combobox.
3. In on_user_selected, load the relevant working steps from your Excel file (or another data source) and update the second Combobox's values property, just like we did for the user list.

内容的提问来源于stack exchange，提问作者JoS