Openpyxl выдает ошибку Module 'openpyxl' has no 'reader' member

import openpyxl

wb = openpyxl.reader.excel.load_workbook(filename="index.xlsx")
print(wb.sheetnames)

wb.active = 0

sheet = wb.active
a = (sheet['A3'].value)
b = (sheet['B3'].value)


c2 = sheet['C2']

c2.value = "TRUE"

wb.save("D:\\Works\\Python\\Piotrowski index\\demo.xlsx")

Код ошибки

Module 'openpyxl' has no 'reader' member

Ответы (1 шт):

Автор решения: Simon Osipov

Вместо:

import openpyxl

Используй:

from openpyxl import load_workbook
wb = load_workbook(filename="index.xlsx")
→ Ссылка