python将多个 excel 合并

import pandas as pd

file1 = 'C:/Users/lenovo/Desktop/作业文件/2019年上期/python卿加波/python2020/L_G/lagouwang/output.xlsx'
file2 = 'C:/Users/lenovo/Desktop/作业文件/2019年上期/python卿加波/python2020/L_G/lagouwang/output2.xlsx'


file = [file1, file2]
li = []
for i in file:
    li.append(pd.read_excel(i))
writer = pd.ExcelWriter('/lagouwang/output.xlsx')
pd.concat(li).to_excel(writer, 'Sheet1', index=False)

writer.save()
print("写入完成！")