Search into excel file with python

Question

First of all, I'm a python beginner so I apologize for the trivial question :D I try to search into a *.xls file a specific word using python (v 2.7)

Short problem description/specification : 1. test.xls is the input file 2. The target word is 2, I want exctract only the cell which contains only 2 and not sometihngs with 2 (e.g. cell value = 2 -> right! cell value=2345-> wrong !!)

below the code :

book = open_workbook('test.xls',on_demand=True)  
item = 2  
row=-1  
n=0  
for name in book.sheet_names():  
    if name.endswith('Traceability Matrix'):  
        sheet = book.sheet_by_name(name)  
        rowIndex = -1  
        for cell in sheet.col(1): #  
            n=n+1  
            if  item  in cell.value:  
                print "VAL ",cell.value  
                print "ROW ",sheet.row(n)  
                break  
    if row != -1:  
        cells = sheet.row(row)  
        for cell in cells:  
            print">>", cell.value  

book.unload_sheet(name)

Now, my output is list of rows which contains NOT only 2 (see wrong case above, point 2), see below the "print" results:

ROW [text:u'SRS5617\nSRS5618\nSRS5619\nSRS5620', text:u'RQ - 5282', empty:'', text:u'Function Plus', text:u'See Note ', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', text:u'Code inspection', text:u'(**), 2']

Someone can help me? Some suggestion?

Thanksssss !!!!!!!!

Firstly, could you please use code formatting and an English dictionary to convert your question from unreadable garbage to something others can understand? Second, do you mean an Excel file or an XML file - the two aren't the same. — jonrsharpe
– jonrsharpe, Commented Jun 26, 2014 at 9:57
if item in cell.value is as clear as it gets: if the cell's value contains 2 (the value of the oddly named variable item), then print it. If you want to check for equality, use ==. — Jasper
– Jasper, Commented Jun 26, 2014 at 10:20
@user3488 The edits I made was to make the question clearer, if you disagree, please tell me why, and how your edits improved your question. Also, if you paste what it is after VAL it will help you to understand your problem of your code — llrs
– llrs, Commented Jun 26, 2014 at 10:30

llrs · Accepted Answer · 2014-06-26 10:23:28Z

2

Your problem is on this lines

        if  item  in cell.value:
            print "VAL ",cell.value
            print "ROW ",sheet.row(n)
            break

That search if a "2" is on the cell.value, not if it is 2.

it could be changed to if int(cell.value) == int(item):

answered Jun 26, 2014 at 10:23

llrs

3,40541 silver badges72 bronze badges

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

1 Comment

llrs Over a year ago

If it helped please mark it as useful with the stick, so other people know how to solve the problem (and to close the question).

Collectives™ on Stack Overflow

Search into excel file with python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related