Problems with openpyxl. Open Excel file with Python

0

I'm trying to read an Excel file but this error message appears.

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()
    
asked by anonymous 20.03.2018 / 05:54

0 answers