擅长:python、mysql、java
<p>您可以按范围(sheet.nrows)迭代Excel工作表,并根据行号获取行值。下面的脚本逐行迭代Excel工作表,并打印出与值123456003匹配的行。你可以修改它以满足你的要求</p>
<p>$cat测试.py</p>
<pre><code>import xlrd
def 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_value
if __name__ == "__main__":
path = "data.xlsx"
open_file(path)
</code></pre>
<p>$python测试.py</p>
<pre><code>[u'NS71282379_67698209', 123456003.0]
</code></pre>