python合并多个excel

import pandas as pd

#合并多个excel的第一个子表
df=pd.read_excel(r"C:\Users\Administrator\Desktop\20210430-0630.xlsx",sheet_name=0)
df1=pd.read_excel(r"C:\Users\Administrator\Desktop\202107-09.xlsx",sheet_name=0)
df2=pd.read_excel(r"C:\Users\Administrator\Desktop\202110-12.xlsx",sheet_name=0)
df3=pd.read_excel(r"C:\Users\Administrator\Desktop\202201-03.xlsx",sheet_name=0)
df4=pd.read_excel(r"C:\Users\Administrator\Desktop\202204.xlsx",sheet_name=0)
df00=df.append(df1).append(df2).append(df3).append(df4)
df00.to_excel(r"C:\Users\Administrator\Desktop\20210430-20220429.xlsx","汇总表",index=0)

#合并同一EXCEL的多个子表
df=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=0)
df1=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=1)
df2=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=2)
df3=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=3)
df4=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=4)
df5=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=5)
df6=pd.read_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测.xlsx",sheet_name=6)
df00=df.append(df1).append(df2).append(df3).append(df4).append(df5).append(df6)
df00.to_excel(r"C:\Users\Administrator\Desktop\11.1-11.27门诊血压未测1.xlsx","总表")