python怎么在excel中定位数据？

Question

比如我for i in sh.col_values(4):

   if i==5:

print 这时能不能显示这个5在第几行，而且显示下一行

Answer 1

谢谢。。我直接把xlsx转成csv了，这样简单些

Answer 2

有安装Excel的机器上

rom win32com.client import constants, Dispatch
class EasyExcel:
 def __init__(self, filename=None):
    self.xlApp = Dispatch('Excel.Application')
    if filename:
        self.filename = filename
        self.xlBook = self.xlApp.Workbooks.Open(filename)
    else:
       print "please input the filename"

 def close(self):
    self.xlBook.Close(SaveChanges=0)
    del self.xlApp

 def getCell(self, sheet, row, col):
    "获取指定sheet,的指定行，和列的值"
    sht = self.xlBook.Worksheets(sheet)
    return sht.Cells(row, col).Value

 def getRange(self, sheet, row1, col1, row2, col2):
    "返回一个二维数组，return a 2d array (i.e. tuple of tuples)"
    sht = self.xlApp.Worksheets(sheet)
    return sht.Range(sht.Cells(row1, col1), sht.Cells(row2, col2)).Value

Answer 3

参见： http://stackoverflow.com/questions/32017850/python-xlwt-search-for-a-specific-value

自己遍历吧。。