从excel中查找对应的SN

#!/usr/bin/python
import xlrd
import os
'''
#read last line  head data
with open('ReadMac.txt',"r") as file:
    file_content = file.readlines() #把全文档读取为一个表，每一行为一个元素
    target = file_content[0] #读取最后一行字符串内容
    #target = file_line_last[:12]  #截取前12个字符并存入变量target
    #print(target)

file.close()
os.system("pause")
'''


with open('ReadMac.txt', 'r',  encoding='utf-8') as file1:
    target = file1.read()
    print(target)
file1.close()
#print(target)


bio_names = f'macHex-MMQ873-PCL.xls'
shu = target
book = xlrd.open_workbook(bio_names)  # 打开文件
table = book.sheets()[0]  # 读取第一个表格
nrows = table.nrows  # 行数
ncols = table.ncols  # 列数
# 搜索关键字符串
for element in range(nrows):
    zip_1 = (table.row_values(1))
    if shu.lower() in (str(table.row_values(element))).lower():
        zip_2 = (table.row_values(element))
        # quit()
        for x, y in zip(zip_1, zip_2):
            print(y)
        # add SN
        with open("SN.txt", "w") as myfile:
            myfile.write(y)
            myfile.close()