Prerequisite:
Python is already installed.
'openpyxl' library is already installed.
Refer below url for installing 'openpyxl' library.
http://automation-home.blogspot.com/2015/12/python-installing-openpyxl-library.html
Excel sheet with sample data.


Executing the python script.


Sample Program:
import os
from openpyxl import load_workbook
wb = load_workbook(os.path.abspath(os.path.join(os.path.dirname(__file__),'testdata/Sample.xlsx')))
sheet = wb.get_sheet_by_name('Sheet1')
c = sheet['B4'].value
print(c)

Note:
Python is already installed.
'openpyxl' library is already installed.
Refer below url for installing 'openpyxl' library.
http://automation-home.blogspot.com/2015/12/python-installing-openpyxl-library.html
Excel sheet with sample data.
Executing the python script.
Sample Program:
import os
from openpyxl import load_workbook
wb = load_workbook(os.path.abspath(os.path.join(os.path.dirname(__file__),'testdata/Sample.xlsx')))
sheet = wb.get_sheet_by_name('Sheet1')
c = sheet['B4'].value
print(c)
Note:
Excel sheet should be closed before executing the script.
Read excel sheet cell value based on row and column number.
Sample Program:
import os
from openpyxl import load_workbook
wb = load_workbook(os.path.abspath(os.path.join(os.path.dirname(__file__),'testdata/Sample.xlsx')))
sheet = wb.get_sheet_by_name('Sheet1')
c = sheet.cell(row=1, column=2).value
print(c)
This is amazing, Thank you Praveen.
ReplyDeleteThanks..really helped
ReplyDelete