循环访问多个excel文件，查找字符串，然后返回相邻单元格中的值。

import os
from openpyxl import load_workbook

def search_excel_files(folder_path, target_string):
    result = []
    for file_name in os.listdir(folder_path):
        if file_name.endswith(".xlsx"):
            file_path = os.path.join(folder_path, file_name)
            workbook = load_workbook(file_path)
            for sheet_name in workbook.sheetnames:
                worksheet = workbook[sheet_name]
                for row in worksheet.iter_rows():
                    for cell in row:
                        if cell.value and isinstance(cell.value, str) and target_string in cell.value:
                            adjacent_cell = worksheet.cell(row=cell.row, column=cell.column + 1)
                            result.append((file_name, sheet_name, cell.value, adjacent_cell.value))
    return result

folder_path = "path/to/excel/files"
target_string = "your_target_string"
result = search_excel_files(folder_path, target_string)
for item in result:
    print("File: {}, Sheet: {}, Value: {}, Adjacent Value: {}".format(*item))