Feb-18-2020, 02:19 PM
As i said in my home computer i don't have microsoft office.
i use libre office. i have renamed the extention to xlsx as intructed in the book i am ready. So maybe that's why openpyxl doesn't work.
in my office computer it works just fine.
trying your proposal
i use libre office. i have renamed the extention to xlsx as intructed in the book i am ready. So maybe that's why openpyxl doesn't work.
in my office computer it works just fine.
trying your proposal
df = pd.read_excel(r'C:\Users\Desktop\Python\example.xlsx')i get the following error:
Error:Traceback (most recent call last):
File "<pyshell#3>", line 1, in <module>
df = pd.read_excel(path)
File "C:\Users\mlakhili\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
io = ExcelFile(io, engine=engine)
File "C:\Users\mlakhili\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\excel\_base.py", line 821, in __init__
self._reader = self._engines[engine](self._io)
File "C:\Users\mlakhili\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\excel\_xlrd.py", line 20, in __init__
import_optional_dependency("xlrd", extra=err_msg)
File "C:\Users\mlakhili\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\compat\_optional.py", line 92, in import_optional_dependency
raise ImportError(msg) from None
ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.