'Unable to open Excel file using Pyexcel
I want to open a simple excel file using PyExcel and here is my code
>>import os
>>import pyexcel as pe
>>print('Directory Path=', os.getcwd())
Directory Path= C:\Users\Contacts\My experimentation
>>sheet = pe.get_sheet(file_name="C:/Users/Contacts/My experimentation/Mylist.xlsx")
This is the name of my Excel file. And this is the error I am getting
Directory Path= C:\Users\Contacts\My experimentation
Traceback (most recent call last):
File "C:/Users/Contacts/My experimentation/abc.py", line 5, in <module>
sheet = pe.get_sheet(file_name="C:/Users/Contacts/My experimentation/Mylist.xlsx")
File "C:\Users\AppData\Local\Programs\Python\Python35\lib\site-packages\pyexcel\core.py", line 36, in get_sheet
named_content = sources.get_sheet_stream(**keywords)
File "C:\Users\AppData\Local\Programs\Python\Python35\lib\site-packages\pyexcel\internal\core.py", line 20, in get_sheet_stream
sheets = a_source.get_data()
Can anyone tell me what I am doing wrong? Thank you!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

