Python 合并文件夹下所有的Excel文件

打开windows窗口选择文件( askopenfilename( ) ) 或文件夹 ( askdirectory() )，以下代码是打开文件夹和文件的示例。

import tkinter.filedialog as tkFD

def __init__(self, root):
    self.ext1 = Button(self.frame[1], text="选择文件", command=self.openfile,width = 10)
        self.ext1.pack(side = LEFT, padx = 2,pady = 10)
        self.txt = Text(self.frame[1],height = 1,width = 80)
        self.txt.pack(side = LEFT, padx = 2,pady = 10)

        self.ext3 = Button(self.frame[3], text="选择根目录", command=self.opendir,width = 10)
        self.ext3.pack(side = LEFT, padx = 2,pady = 10)       
        self.path = Text(self.frame[3],height = 1,width = 40)
        self.path.pack(side = LEFT, padx = 2,pady = 10)

def openfile(self):
        self.filename=tkFD.askopenfilename(filetypes