openpyxl合并文件夹内全部excel文件

import os
from openpyxl import Workbook
from openpyxl import load_workbook
folder_path = select_folder_dialog.folder
save_path1 = os.path.join(folder_path, "merged.xlsx")
merged_workbook = Workbook()
merged_sheet = merged_workbook.active
first_file = True
for filename in os.listdir(folder_path):
    if filename.endswith(".xlsx") or filename.endswith(".xls"):
        file_path = os.path.join(folder_path, filename)
        workbook = load_workbook(file_path)
        sheet = workbook.active
        if first_file:
            for row in sheet.iter_rows(values_only=True):
                merged_sheet.append(row)
            first_file = False
        else:
            for row in sheet.iter_rows(min_row=2, values_only=True):
                merged_sheet.append(row)
        workbook.close()
merged_workbook.save(save_path1)
merged_workbook.close()
print("合并完成！")