# -*- coding: utf-8 -*-import tkinter as tkfrom tkinter import ttkfrom tkinter import filedialogimport pandas as pd
def load_excel_to_treeview():    file_path = filedialog.askopenfilename(        filetypes=[("Excel Files", "*.xlsx *.xls")]    )    if not file_path:        return
    # 根据扩展名选择引擎    if file_path.endswith('.xlsx'):        engine = 'openpyxl'    elif file_path.endswith('.xls'):        engine = 'xlrd'    else:        return
    try:        df = pd.read_excel(file_path, engine=engine)    except Exception as e:        print("读取文件失败:", e)        return
    # 清空Treeview    for item in tree.get_children():        tree.delete(item)
    # 设置列    tree["columns"] = list(df.columns)    tree["show"] = "headings"
    # 配置列标题    for col in tree["columns"]:        tree.heading(col, text=col)        tree.column(col, width=70)
    # 插入数据    for index, row in df.iterrows():        tree.insert("", "end", values=list(row))

# 创建主窗口root = tk.Tk()root.title("Excel数据查看器")
# 创建Treeviewtree = ttk.Treeview(root)tree.pack(fill="both", expand=True)
# 添加按钮btn = tk.Button(root, text="打开Excel文件", command=load_excel_to_treeview)btn.pack(pady=10)
root.mainloop()