循环遍历子文件夹中的Excel文件，并将数据复制并粘贴到一个工作表中

import os

excel_files = []
folder_path = "你的文件夹路径"

for folder_name, subfolders, filenames in os.walk(folder_path):
    for filename in filenames:
        if filename.endswith(".xlsx") or filename.endswith(".xls"):
            excel_files.append(os.path.join(folder_name, filename))

from openpyxl import load_workbook
from openpyxl.utils import get_column_letter

# 创建一个新的工作簿
new_workbook = Workbook()
new_sheet = new_workbook.active

for file in excel_files:
    # 打开Excel文件
    workbook = load_workbook(file)
    sheet = workbook.active
    
    # 遍历每行数据
    for row in sheet.iter_rows(values_only=True):
        # 复制数据到新工作表中
        new_sheet.append(row)

# 保存新工作簿
new_workbook.save("新工作簿.xlsx")