How to get cell value 'A1', 'A2'?

Question

Python

There is an xlrd library that has a function that returns the name of the cell:
print (xlrd.cellname(row, col))
Is there a function in this library:
print (xlrd.get_value('A1'))

Answer 1

Apparently, just like this

import xlrd 
book = xlrd.open_workbook("***.xlsx")
sheet = book.sheet_by_index(0)
print(sheet.cell_value(rowx=0, colx=0))

where are the column number and row number. But if you use openpyxlrowx=0, colx=0

from openpyxl import load_workbook
wb = load_workbook(filename = '***.xlsx')
sheet_ranges = wb['Лист1']
print(sheet_ranges['A1'].value)

It will all work out ;)