Reading particular cell value from excelsheet in python
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)