import pandas as pd
import tkinter as tk
from tkinter import *
from tkinter import filedialog
from pandas import ExcelWriter
from pandas import ExcelFile
def main()。
df1= pd.read_excel (excel_filepath,"Sheet") ##這里我正在讀取檔案 ##。
df2= pd.read_excel (excel_filepath1,"Sheet2")
df= pd.read_excel (excel_filepath2,"Sheet1")
回傳。
r=tk.Tk()
r.title('')
text1 = tk.Label(r, text="輸入INPUT和EXP Excel檔案的檔案路徑。")
text1.grid(row = 1, column = 1)
excel_filepath = tk.StringVar()
df1= pd.read_excel (str(excel_filepath.get()),"Sheet")## this is the line showing error ##
heading1=list((df1.columns.values)) ## this is the line readingings ##
uj5u.com熱心網友回復:
我創建了一個加載按鈕。當點擊時,它將讀取列并將更新下拉選單:
def Load_excel_data()。
在此輸入代碼`df1= pd.read_excel(excel_filename)
heading1=list((df1.columns.values))
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/319470.html
標籤:
下一篇:吊艙中暫停容器的生命周期
