python合并excel工作簿_使用python将excel工作簿工作表合并为一个工作表

在shell中执行，指示包含excel文件的文件夹的路径（确保定义所有工作簿的参数正确），然后执行excel输出文件，如下所示：python script.py < your/ final/output.xlsx>

脚本.py：import pandas as pd

import sys

import os

import glob

input_path = sys.argv[1]

output_file = sys.argv[2]

all_workbooks = glob.glob(os.path.join(input_file, '*.xlsx'))

all_df = []

for workbook in all_workbooks:

all_worksheets = pd.read_excel(workbook, sheetname='Output', index_col=None)

for worksheet, data in all_worksheets.items:

all_df.append(data)

data_concatenated = pd.concat(all_df, axis=0, ignore_index=True)

writer = pd.ExcelWriter(output_file)

data_concatenated.to_excel(writer, sheetname='concatenated_Output', index=False)

writer.save()