0
I am trying to read an Excel file but it appears this error message.
Warning (from warnings module):
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/openpyxl/reader/worksheet.py", line 318
warn(msg)
UserWarning: Unknown extension is not supported and will be removed
<class 'openpyxl.workbook.workbook.Workbook'>
Warning (from warnings module):
File "/Users/edson/PycharmProjects/Projetos/Projeto_10.py", line 7
wb.get_sheet_names()
DeprecationWarning: Call to deprecated function get_sheet_names (Use wb.sheetnames).
Using Python3 on Mac
#Abrir planilha do Excel
import openpyxl
wb = openpyxl.load_workbook('cata_logo.xlsx')
type(wb)
print(type(wb))
wb.get_sheet_names()
Are you saying that the function
get_sheet_names
is obsolete, and is asking to use the functionwb.sheetnames
.– NoobSaibot
Related: https://stackoverflow.com/questions/34322231/python-2-7-openpyxl-userwarning
– NoobSaibot