利用pandas 和 ttk.Treeviews制作xlsx视图工具

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

import tkinter as tk from tkinter import ttk import pandas as pd import tkinter.messagebox as msgbox   def Start():     msgbox.showinfo('提示', 'OK')     fp = pd.read_excel("./test.xlsx")     for i in tree.get_children():         tree.delete(i)     for _ in range(len(fp.index.values)):         tree.insert('','end',value=tuple(fp.iloc[_,[0,1,2]].values))          win = tk.Tk() #win.wm_attributes('-topmost',1) win.geometry("300x1000+10+10") #ttk.Button(win,text="Import it",command=Start).pack() columns = ("A","B","C") tree = ttk.Treeview(win,show="headings",columns=columns,height=45) tree.column("A",width=100,anchor='center') tree.heading("A",text="列A") tree.pack() win.after(500,Start)   win.mainloop()

　　

 

 

参考：https://blog.csdn.net/weixin_43849588/article/details/104968231