Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get line number in excel sheet using python?

Tags:

python

xlrd

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!

like image 634
MHS Avatar asked Mar 21 '13 07:03

MHS


2 Answers

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

like image 89
arulmr Avatar answered Oct 05 '22 02:10

arulmr


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.

like image 20
Anthon Avatar answered Oct 05 '22 00:10

Anthon