将多个excel文件中的数据追加到单个excel文件中，而不使用python pandas覆盖。

import openpyxl

merged_workbook = openpyxl.Workbook()
merged_sheet = merged_workbook.active

excel_files = ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']  # 替换为实际的文件名列表

for file in excel_files:
    workbook = openpyxl.load_workbook(file)
    sheet = workbook.active

    # 遍历源文件的每一行，将数据追加到合并后的文件中
    for row in sheet.iter_rows(values_only=True):
        merged_sheet.append(row)

    workbook.close()

merged_workbook.save('merged_file.xlsx')
merged_workbook.close()