如何测试一个Excel数组中的元素在另一个Excel数组中也有介绍

import openpyxl

def test_excel_arrays(file1, file2):
    # 读取两个Excel文件
    workbook1 = openpyxl.load_workbook(file1)
    workbook2 = openpyxl.load_workbook(file2)

    # 获取第一个工作表的数据
    worksheet1 = workbook1.active
    array1 = []
    for row in worksheet1.iter_rows(values_only=True):
        array1.extend(row)

    # 获取第二个工作表的数据
    worksheet2 = workbook2.active
    array2 = []
    for row in worksheet2.iter_rows(values_only=True):
        array2.extend(row)

    # 测试array1中的元素是否存在于array2中
    result = []
    for element in array1:
        if element in array2:
            result.append("存在")
        else:
            result.append("不存在")

    # 将测试结果写入新的Excel文件
    result_file = "测试结果.xlsx"
    workbook = openpyxl.Workbook()
    worksheet = workbook.active
    for i, element in enumerate(array1):
        worksheet.cell(row=i+1, column=1, value=element)
        worksheet.cell(row=i+1, column=2, value=result[i])
    workbook.save(result_file)

    print("测试完成，结果已保存在文件：", result_file)

# 测试示例
test_excel_arrays("文件1.xlsx", "文件2.xlsx")