用 tkinter 實現選擇路徑打開 excel ,並用 tree view 顯示


# -*- coding: utf-8 -*-
from tkinter import filedialog
import tkinter as tk
from tkinter import ttk
from ttkthemes import ThemedStyle
import pandas as pd
def op():
 sfname = filedialog.askopenfilename(title='選擇', filetypes=[('Excel', '*.xlsx'), ('All Files', '*')])
 return sfname
def read(sfname):
 df = pd.read_excel(sfname,header=0)
 cols = list(df.columns)
 return df,cols
def 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 tree
def 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()
#Python #tkinter #treeview






你可能感興趣的文章

實作 To do List SPA(下):後端及 API 串接部份

實作 To do List SPA(下):後端及 API 串接部份

MTR04_1106

MTR04_1106

簡易 Regular Expression 入門指南

簡易 Regular Expression 入門指南




Sponsored



Comments