Python使用教程【二】：Python合并多个Excel表格到一个表格中

1、源码

import pandas as pd, os

def concat_excel():
    excelInput = input("请输入Excel名：").split(' ')
    combineName = 'combine.xlsx'

    excelList = []
    for i in excelInput:
      excelList.append(pd.read_excel(i))

    excelConcat =pd.concat(excelList)
    excelConcat.to_excel(combineName, index=False)


if __name__ == "__main__":
    concat_excel()

2、输入

• 输入多个Excel时以空格为分隔符