import xlrd
data = xlrd.open_workbook(r'英语应用能力考试AB级.xlsx')
sheet = data.sheet_by_index(0)
c = []
k = 1
rows: list = sheet.row_values(0)
for i in range(len(rows)):
c.append(sheet.col_values(i))
# s2 = int(input('输入学号序列号'))
s = input('输入查找的数据信息:')
s1 = 0
for j in range(len(c[0])):
for i in range(len(rows)):
try:
if s == c[i][j]:
print(k,end=' ')
s1 = j
for i1 in range(len(rows)):
print(c[i1][s1], end=' ')
print(' ')
k += 1
break
else:
continue
except Exception as f:
print(f)
if float(s) == c[i][j]:
print(k,end=' ')
s1 = j
for i1 in range(len(rows)):
print(c[i1][s1], end=' ')
print(' ')
k += 1
break
else:
continue
if s1 == 0:
print("未查找到该信息!")