如何在多个excel中搜索值并汇总到一个excel工作簿

import os
from openpyxl import load_workbook

# 创建目标文件
target_file = "汇总.xlsx"
target_workbook = load_workbook(target_file)
target_sheet = target_workbook.active

# 遍历要搜索的Excel文件
search_files = ["文件1.xlsx", "文件2.xlsx", "文件3.xlsx"]
for file in search_files:
    # 打开要搜索的文件
    search_workbook = load_workbook(file)
    search_sheet = search_workbook.active

    # 搜索目标值并汇总到目标文件
    target_value = "目标值"
    for row in search_sheet.iter_rows():
        for cell in row:
            if cell.value == target_value:
                target_sheet.append([cell.value])

    # 关闭要搜索的文件
    search_workbook.close()

# 保存目标文件
target_workbook.save(target_file)
target_workbook.close()