python 将多个Excel中的sheet合并

import pandas as pd
import xlrd
import os
import xlrd
from  pandas import DataFrame
from openpyxl import load_workbook
dfs =[]
path=r"C:Users苏图Desktop流转表"
file_name_li = os.listdir(r'C:Users苏图Desktop流转表')
for fname in file_name_li:
    if fname.endswith(".xlsx") and fname !='final.xlsx':
        df = pd.read_excel(
            path+'\'+fname,
            sheet_name='交易明细'
        )

        dfs.append(df)
result = pd.concat(dfs,ignore_index=True)
result.to_excel(path+'\'+'final.xlsx',index=False)