excel合并

import os
import xlrd
import pandas as pd
import tkinter as tk
from tkinter import filedialog

root = tk.Tk()
root.title("Excel处理")
root.geometry('700x500')
root.resizable(width=True,height=True)


def ExcelMerge():
    #文件夹弹窗
    path = filedialog.askdirectory()
    file_list = []
    dfs = []
    #获取文件
    for root,dirs,files in os.walk(path):
        for file in files:
            file_path = os.path.join(root,file)
            file_list.append(file_path)
            df = pd.read_excel(file_path)
            dfs.append(df)
    #合并文件
    df = pd.concat(dfs)

    df.to_excel("{}\\result.xlsx".format(path),index=False)

tk.Button(root,text="excel合并",command=ExcelMerge).grid(row=0,column=0,padx=50,ipadx=30,pady=30)
root.mainloop()