使用xlrd搜索excel

Question

我试图教会自己如何使用xlrd来完成一个(概念上)简单的任务：

我想通过raw_input从用户获取一个字符串，并在excel表中搜索该字符串。

找到后，我希望程序只打印单元格行。

以下是我的非工作代码：

import xlrd
from xlrd import open_workbook

book = open_workbook('simple.xls')

sheet = book.sheet_by_index(0)

city = raw_input("> ")
for rowi in range(sheet.nrows):
    row = sheet.row(rowi)
    for coli, cell in enumerate(row):
        if cell.value == city:
            loc = cell.row
            ??????????????
cell = sheet.cell(loc, 9)

print "The Ordinance Frequency is %r" % cell.value

Answer 1

尝试以循环遍历行的方式遍历列。

for r in range(sheet.nrows): for c in range(sheet.ncols): cell = sheet.cell(r, c) if cell.value == city: loc = r //index of interesting row