How to get line number in excel sheet using python?

Question

I have an Excel sheet like this:

  A B C D E F G
1 0 0 0
2   0 0
3 0
4
5 0 0 0 0 0 0 0
6 0 0   0

And every '0' represents some data values, I am reading the values and comparing them with my original data, when the data match fails it returns a message. What I want is to return the line number of excel sheet as well as the column number or particularly the CELL location. Please help me doing this!

if you are comparing cell values then you have their index which is line number and column number, otherwise you can start counter on row and column loop with increment on every iteration, this will tell you exact column number and row number. — sharafjaffri, Mar 21 '13 at 07:40

score 33 · Accepted Answer · edited Mar 21 '13 at 12:34

33

Try this:

import xlrd
workbook = xlrd.open_workbook('book.xls')
for sheet in workbook.sheets():
    for row in range(sheet.nrows):
        for column in range(sheet.ncols):
            print "row::::: ", row
            print "column:: ", column
            print "value::: ", sheet.cell(row,column).value

It will give you exact row, column numbers and cell value

edited Mar 21 '13 at 12:34

Anthon

69,918
32
186
246

answered Mar 21 '13 at 07:42

arulmr

8,620
9
54
69

score 2 · Answer 2 · answered Mar 21 '13 at 07:42

2

Keep track of the column and row while iterating over the worksheet. An xlrd Cell does not keep track of where they 'live' in the sheet.

answered Mar 21 '13 at 07:42

Anthon

69,918
32
186
246

score 1 · Answer 3 · answered Mar 21 '13 at 07:43

1

if you are comparing cell values then you have their index which is line number and column number, otherwise you can start counter on row and column loop with increment on every iteration, this will tell you exact column number and row number.

answered Mar 21 '13 at 07:43

sharafjaffri

2,134
3
30
47

How to get line number in excel sheet using python?

3 Answers3

Linked