在多个excel文件中搜索特定字符串

import os
from openpyxl import load_workbook

def search_string_in_files(folder_path, search_string):
    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)
            for sheet in workbook.sheetnames:
                worksheet = workbook[sheet]
                for row in worksheet.iter_rows():
                    for cell in row:
                        if cell.value and search_string in str(cell.value):
                            print(f"在文件 {filename} 的工作表 {sheet} 中找到匹配项：{cell.value}")

# 指定要搜索的文件夹路径和特定字符串
folder_path = "你的文件夹路径"
search_string = "要搜索的特定字符串"

# 调用函数进行搜索
search_string_in_files(folder_path, search_string)