Python-сообщество

 import xlrd
book = xlrd.open_workbook('Name1.xlsx')
names = book.sheet_names()
sheet = book.sheet_by_name(names[0])
data = sheet.cell(row, cell).value
book.release_resources()
del book
########################################
book = xlrd.open_workbook('Name2.xlsx ')
names = book.sheet_names()
sheet = book.sheet_by_name(names[0])
data2 = sheet.cell(row,cell).value
book.release_resources()
del book

 from openpyxl import load_workbook
wb = load_workbook('Shablon.xlsx')
print (wb.get_sheet_names())
wb = load_workbook('r.xlsx ')
print (wb.get_sheet_names())

 ['Лист1']
Traceback (most recent call last):
  File "C:\My PY G\Buh111\excel222.py", line 8, in <module>
    wb = load_workbook('r.xlsx ')
  File "C:\Program Files\Python36\lib\site-packages\openpyxl\reader\excel.py", line 171, in load_workbook
    archive = _validate_archive(filename)
  File "C:\Program Files\Python36\lib\site-packages\openpyxl\reader\excel.py", line 108, in _validate_archive
    raise InvalidFileException(msg)
openpyxl.utils.exceptions.InvalidFileException: openpyxl does not support .xlsx  file format, please check you can open it with Excel first. Supported formats are: .xlsx,.xlsm,.xltx,.xltm
>>>