使用python将多个excel文件合并为一个主文件。

import pandas as pd
import os

def merge_excel_files(input_folder, output_file):
    all_data = pd.DataFrame()
    for file_name in os.listdir(input_folder):
        if file_name.endswith(".xlsx") or file_name.endswith(".xls"):
            file_path = os.path.join(input_folder, file_name)
            df = pd.read_excel(file_path)
            all_data = all_data.append(df, ignore_index=True)
    all_data.to_excel(output_file, index=False)

input_folder = "输入文件夹路径"
output_file = "输出文件路径"
merge_excel_files(input_folder, output_file)