Searching the string and getting the row and column value

Question

How to search the particular string in the excel sheet and getting the row and column value of that particular string in the excel sheet using xlrd in python? Can any one help me please?

import xlrd
workbook = xlrd.open_workbook("1234.xls")
worksheet = workbook.sheet_by_name('firstpage')

only this much i tried

You can add your code that you tried to the question, to make it more clear and understandable. — Sujay Narayanan
– Sujay Narayanan, Commented Aug 19, 2015 at 8:29

Sujay Narayanan · Accepted Answer · 2015-08-19 08:55:47Z

18

I think this is what you are looking for , Here you go,

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

best,

answered Aug 19, 2015 at 8:55

Sujay Narayanan

4874 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sujay Narayanan Over a year ago

dood you dont have to call me sir. I am your friend enjoy. Kindly Upvote if it helped.

frogbandit · Accepted Answer · 2015-08-19 08:50:31Z

1

Say you're searching for a string s:

for row in range(sh.nrows):
    for column in range(sh.ncols):
        if s == sh.cell(row, column).value:  
            return (row, column)

answered Aug 19, 2015 at 8:50

frogbandit

5711 gold badge8 silver badges21 bronze badges

1 Comment

LearneR Over a year ago

If my condition if cell.value == "particularString" : evaluates to be true, then I want to pick the value in the cell next to it. How to do that?

Collectives™ on Stack Overflow

Searching the string and getting the row and column value

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related