用 tkinter 实现选择路径打开 excel ，并用 tree view 显示

引注资料
https://blog.csdn.net/weixin_43184622/article/details/107054131
我是看了上述引注资料的範例后，用另外一种想法改的

# -*- coding: utf-8 -*-from tkinter import filedialogimport tkinter as tkfrom tkinter import ttkfrom ttkthemes import ThemedStyleimport pandas as pddef op(): sfname = filedialog.askopenfilename(title='选择', filetypes=[('Excel', '*.xlsx'), ('All Files', '*')]) return sfnamedef read(sfname): df = pd.read_excel(sfname,header=0) cols = list(df.columns) return df,colsdef show(frame,df,cols): tree = ttk.Treeview(frame) tree.pack() tree["columns"] = cols for i in cols:    tree.column(i,anchor="center")    tree.heading(i,text=i,anchor='center') for index, row in df.iterrows():    tree.insert("",'end',text = index,values=list(row)) return treedef oas(): global root filename = op() data,c = read(filename) tree = show(root,data,c) tree.place(relx=0,rely=0.1,relheight=0.7,relwidth=1)def main(): global root root = tk.Tk() style = ThemedStyle(root) style.set_theme("breeze") root.geometry("1600x1000") B1 = tk.Button(root, text="打开",command = oas).pack() root.mainloop()if __name__=='__main__':    main()