#!/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()
标签:target,zip,excel,查找,SN,file,print,table,open
From: https://www.cnblogs.com/wang-xiao-shuai/p/16963317.html