为了创建一个Python GUI应用程序，可以读取Excel文件并根据选定的班级显示学生信息和照片，你可以使用`tkinter`库构建界面，并结合`pandas`处理Excel数据以及`PIL` (Pillow) 库展示图片。 ### 步骤概览 1. **安装必要的库**: - `pandas`: 用于读取 Excel 文件。 - `openpyxl`: 支持 `.xlsx` 格式的 Excel 文件读写操作。 - `PIL/Pillow`: 显示图像。 2. **准备你的Excel表格**: 确保每一行包含每个学生的相关信息如：班级、名字及对应的照片路径等字段。 3. **编写主程序逻辑**, 包含但不限于以下几个部分： #### 导入所需的模块: ```python import tkinter as tk from tkinter import ttk, messagebox import pandas as pd from PIL import ImageTk, Image ``` #### 定义加载Excel函数: 此函数负责将指定列从Excel表单中提取出来形成DataFrame结构的数据集. ```python def load_excel_data(file_path): try: df = pd.read_excel(file_path) return df except Exception as e: print(f"Error loading excel file {e}") return None ``` #### 创建应用窗口类: 这是一个自定义的应用窗口组件，在这里添加所有需要的小部件(widgets),例如组合框(ComboBox)，标签(Label)等等... ```python class StudentApp(tk.Tk): def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs) self.title("Student Information Viewer") # 初始化变量 self.class_var = tk.StringVar() self.selected_class = "" self.data_frame = load_excel_data('students.xlsx') if not isinstance(self.data_frame, pd.DataFrame): raise ValueError("Failed to read the data.") classes = sorted(set([str(c).strip() for c in self.data_frame['Class'].tolist()])) combobox_label = ttk.Label(text="Select Class:") combobox_label.pack(side=tk.TOP) combo_box = ttk.Combobox(self,textvariable=self.class_var, values=classes,state='readonly') combo_box.bind('<<ComboboxSelected>>', lambda event: self.on_combo_select()) combo_box.current(0) combo_box.pack() container = ttk.Frame(self) container.pack(fill=tk.BOTH, expand=True) canvas = tk.Canvas(container,bg='#FFFFFF') scrollbar = ttk.Scrollbar(container, orient="vertical", command=canvas.yview) scrollable_frame = ttk.Frame(canvas) scrollable_frame.bind( "<Configure>", lambda e: canvas.configure(scrollregion=canvas.bbox("all")) ) canvas.create_window((0, 0), window=scrollable_frame, anchor="nw") canvas.configure(yscrollcommand=scrollbar.set) canvas.pack(side="left", fill="both", expand=True) scrollbar.pack(side="right", fill="y") self.container = container self.canvas = canvas self.scrollable_frame = scrollable_frame self.update_display() def on_combo_select(self,*args,**kwargs): selected_value = self.class_var.get().strip() if len(selected_value)>0 and selected_value != self.selected_class: self.selected_class = selected_value self.update_display() def update_display(self): class_df = self.data_frame[self.data_frame['Class'] == self.selected_class] widgets_to_destroy = [] for widget in reversed(list(self.scrollable_frame.children.values())): widgets_to_destroy.append(widget) [widget.destroy() for widget in widgets_to_destroy] row_index = 0 for index,row in class_df.iterrows(): name = str(row['Name']).strip() photo_path = str(row['PhotoPath']).strip() label_name = f"name_{row_index}" img_tag = f"img_{row_index}" lbl_student = ttk.Label(master=self.scrollable_frame, text=f"{name}", padding=(5, 5)) lbl_student.grid(column=0, row=row_index, padx=4,pady=4) try: pil_image = Image.open(photo_path) resized_img=pil_image.resize((80, 80)) render = ImageTk.PhotoImage(resized_img) image_label = ttk.Label(image=render,master=self.scrollable_frame,) setattr(self,image_tag,render) # Keep reference of PhotoImage objects. image_label.image = getattr(self,img_tag) image_label.grid(column=1, row=row_index, padx=4,pady=4) except IOError: error_lbl = ttk.Label(text="无法加载图片", master=self.scrollable_frame, foreground="#FF0000" ) error_lbl.grid(column=1, row=row_index, padx=4,pady=4) row_index += 1 if __name__=="__main__": app = StudentApp() app.mainloop() ``` 以上代码段实现了基于用户选择的不同班级动态更新界面上的学生列表及其头像的功能。注意实际项目部署前还需要完善异常捕捉机制和其他细节优化工作。