Question : how to find a string in an excel with xlrd
Answered by : clean-chinchilla-kwl4ihy1blpd
from xlrd import open_workbook
book = open_workbook(workbookName)
for sheet in book.sheets(): for rowidx in range(sheet.nrows): row = sheet.row(rowidx) for colidx, cell in enumerate(row): if cell.value == "particularString" : print sheet.name print colidx print rowidx
Source : https://stackoverflow.com/questions/32090002/searching-the-string-and-getting-the-row-and-column-value | Last Update : Fri, 17 Jul 20