您是否想做这样的事情?

Do you maybe want to do something like this?

fnames = ['sample1.xls', 'sample2.xls']
all_info = [pd.read_excel(f, 'Sheet1') for f in fnames]
df = pd.concat(all_info)
df.to_excel("all_info.xlsx")

这里，all_info 是一个 DataFrame 列表，其中每个元素都保存着不同的 Excel 数据.然后将它们连接成一个 DataFrame 并保存到磁盘...

Here, all_info is a list of DataFrames, where each elements is holding the different Excel Data. Then they are concatenated into one DataFrame and saved to disk...