python 多个excel文件合成一个excel的多张表(多个xlsx文件合成一个xlsx的多张表)
代码如下:
import pandas as pd
from pathlib import Path
# 生成结果文件
file_path = pd.ExcelWriter('./result/analysis.xlsx',engine='xlsxwriter')
workbook = pd.ExcelWriter(file_path)
#待核成文件目录
folder_path = Path('/home/wu/Mytools/temporary/')
# 获取表格列表的文件路径
origin_file = folder_path.glob('*.xlsx')
print(origin_file)
# 循环遍历表格
for i in origin_file:
stem_name = i.stem
#print(stem_name)
data = pd.read_excel(i)
print(data)
data.to_excel(workbook,sheet_name = stem_name,index=False,header=False)
workbook.save()
workbook.close()