import xlrd
wb2=xlrd.open_workbook(r'C:\Users\pupu\Desktop\下载 (2).xls')
ws2=wb2.sheet_by_name('sheet1')
a=ws2.nrows #最大行数
for sa in range(a):
for bs in ws2.row_values(sa):
if bs == 'Z': #Z是你要寻找的内容
print(ws2.row_values(sa))
print(sa+1) #列表从0位起读,所以要加1