打开特定Excel文件/工作表以获取特定内容单元格位置

Question

我有一堆Excel文件和它们对应的工作表编号。我需要用Python去这些工作表里找出某个特定内容的单元格位置。有人能帮我指出我代码里的错误吗？提前谢谢！

import xlrd
value = 'Avg.'
filename = ('C:/002 Av SW W of 065 St SW 2011-Jul-05.xls', 'C:/003 Avenue SW West of 058 Street SW 2012-Jun-23.xls')
sheetnumber = ('505840', '505608')
dictionary = dict(zip(filename, sheetnumber))
for item in dictionary:
    book = xlrd.open_workbook(item)
    sheet = book.sheet_by_name(dictionary[key])
    for row in range(sheet.nrows):
        for column in range(sheet.ncols):
            if sheet.cell(row,column).value == value:
                print row, column

Answer 1

你不需要创建一个字典。只需遍历 zip(filename, sheetnumber) 就可以了：

for name, sheet_name in zip(filename, sheetnumber):
    book = xlrd.open_workbook(name)
    sheet = book.sheet_by_name(sheet_name)
    for row in range(sheet.nrows):
        for column in range(sheet.ncols):
            if sheet.cell(row,column).value == value:
                print row, column