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?
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)
To access the value for a specific cell:
cell_value = worksheet.cell(row_number, column_number).value
To access the value for a specific cell you would use:
value = worksheet.cell(row, column)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With