Reading particular cell value from excelsheet in python

Question

I want to get particular cell values from excelsheet in my python script. I came across xlrd, xlwt, xlutils modules for reading/writing to/from excelsheet.

I created myfile.xls with hi, hello, how in first column's 3 cells.

sample code :-

import xlrd

workbook = xlrd.open_workbook('myfile.xls')
worksheet = workbook.sheet_by_name('Sheet1')
num_rows = worksheet.nrows - 1
curr_row = -1
while curr_row < num_rows:
        curr_row += 1
        row = worksheet.row(curr_row)
        print row

output :-

[text:u'hi']
[text:u'hello']
[text:u'how']

I want to read specific cell values from excelsheet, can someone suggest me if there is a way to do that?

StvnW · Accepted Answer · 2013-10-20 17:32:05Z

24

To access the value for a specific cell you would use:

value = worksheet.cell(row, column)

answered Oct 20, 2013 at 17:32

StvnW

1,83214 silver badges19 bronze badges

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

2 Comments

npatel Over a year ago

I tried it value = worksheet.cell(1, 1), but it is giving error self._cell_types[rowx][colx], IndexError: array index out of range. I am using python2.5 and all required modules are installed.

StvnW Over a year ago

The first column or row is 0, not 1.

Cronje Fourie · Accepted Answer · 2020-09-16 13:53:27Z

7

This code is to select certain cells from Excel using Python:

import openpyxl

wb = openpyxl.load_workbook(r'c:*specific destination of file*.xlsx')
sheet = wb.active
x1 = sheet['B3'].value
x2 = sheet['B4'].value
y1 = sheet['C3'].value
y2 = sheet['C4'].value
print(x1,x2,y1,y2)

answered Sep 16, 2020 at 13:53

Cronje Fourie

711 silver badge1 bronze badge

Comments

Bharath_Raja · Accepted Answer · 2020-01-06 13:49:20Z

5

To access the value for a specific cell:

cell_value = worksheet.cell(row_number, column_number).value

answered Jan 6, 2020 at 13:49

Bharath_Raja

6608 silver badges18 bronze badges

Comments

roelofs · Accepted Answer · 2017-11-15 07:52:27Z

0

The code below will help you in solving the problem:

worksheet = workbook.sheet_by_name('Sheet1')
num_rows = worksheet.nrows - 1
curr_row = 0
while curr_row < num_rows:
        curr_row += 1
        row = worksheet.row(curr_row)
        print row[0].value

edited Nov 15, 2017 at 7:52

roelofs

2,19021 silver badges25 bronze badges

answered Nov 15, 2017 at 7:10

jebran

313 bronze badges

Comments

Bharathiraja · Accepted Answer · 2021-06-11 10:37:51Z

0

Code snippet for reading xlsx file in python using xlrd

import xlrd

def readdata():
    workbook = xlrd.open_workbook("src.xlsx", "rb")
    sheets = workbook.sheet_names()
    for sheet_name in sheets:
        sh = workbook.sheet_by_name(sheet_name)
        for rownum in range(1, sh.nrows): #skipping header of the xlsx
           print(sh.cell(rownum, 2)) # e.g Printing all rows value of 3rd column

readdata()

if any error 'No Module found xlrd'. Install xlrd using below command in terminal

pip install xlrd

answered Jun 11, 2021 at 10:37

Bharathiraja

8421 gold badge13 silver badges23 bronze badges

1 Comment

Taylrl Over a year ago

I get an error telling me that .xlsx is not supported. Apparently xlrd has removed support for anything other than .xls files, see stackoverflow.com/questions/65254535/…

Collectives™ on Stack Overflow

Reading particular cell value from excelsheet in python

5 Answers 5

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related