您可以按range（sheet.nrows）迭代Excel工作表，并根据行号获取行值。下面的脚本逐行迭代Excel工作表并打印出匹配值123456003的行。您可以对其进行修改以满足您的要求
$猫test.py
import xlrddef open_file(path): wb = xlrd.open_workbook(path) sheet = wb.sheet_by_index(0) for row_num in range(sheet.nrows): row_value = sheet.row_values(row_num) if row_value[1] == 123456003: print row_valueif __name__ == "__main__": path = "data.xlsx" open_file(path)
$ python test.py
[u'NS71282379_67698209', 123456003.0]
