python xlrd string match

Question

I couldnt find anything in the API. Is there a way to return the row number or coordinate of a cell based on a string match? For instance: You give the script a string and it scans through the .xls file and when it finds a cell with the matching string, it returns the coordinate or row number.

Joran Beasley · Accepted Answer · 2012-06-07 16:13:26Z

7

for i in range(sheet.nrows):
     row = sheet.row_values(i)
     for j in range(len(row)):
          if row[j] == search_value:
                return i,j
return None

something like that... just a basic search

answered Jun 7, 2012 at 16:13

Joran Beasley

114k13 gold badges167 silver badges187 bronze badges

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

2 Comments

Blainer Over a year ago

Im getting this error File "mp3.py", line 22 return i,j SyntaxError: 'return' outside function

Joran Beasley Over a year ago

well its not meant to be a direct copy and paste you need to put it in a function and set the sheet value by extracting the correct sheet from the workbook i think its like woorkbook.getsheetbyindex(0)

EAM13 · Accepted Answer · 2015-10-24 20:00:04Z

0

You could try the following function, thank you Joran

def look4_xlrd (search_value, sheet) :
lines = []
columns = []
for i in range (sheet.nrows) :
    row = sheet.row_values(i)
    for j in range(len(row)) :
        if row[j] == search_value :
            lines.append(i)
            columns.append(j)
    del row
return lines, columns

edited Oct 24, 2015 at 20:00

answered Oct 24, 2015 at 19:53

EAM13

11 bronze badge

Collectives™ on Stack Overflow

python xlrd string match

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related