search

dunovank / jupyter-themes

Custom Jupyter Notebook Themes
MIT License
9.74k stars 1.06k forks source link

error when tryng to read excel file (dark mode) #401

Open bodytexture opened 4 years ago

bodytexture commented 4 years ago

error when tryng to read excell file

(started after activating dark mode as from this instructions: https://medium.com/@rbmsingh/making-jupyter-dark-mode-great-5adaedd814db)

gestionale=pd.read_excel(r'‪C:\Users\Francesco\Desktop\GESTIONALE.xlsx')

OSError Traceback (most recent call last)

in ----> 1 gestionale=pd.read_excel(r'‪C:\Users\Francesco\Desktop\GESTIONALE.xlsx') ~\Miniconda3\lib\site-packages\pandas\io\excel\_base.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, verbose, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, mangle_dupe_cols, **kwds) 302 303 if not isinstance(io, ExcelFile): --> 304 io = ExcelFile(io, engine=engine) 305 elif engine and engine != io.engine: 306 raise ValueError( ~\Miniconda3\lib\site-packages\pandas\io\excel\_base.py in __init__(self, io, engine) 819 self._io = stringify_path(io) 820 --> 821 self._reader = self._engines[engine](self._io) 822 823 def __fspath__(self): ~\Miniconda3\lib\site-packages\pandas\io\excel\_xlrd.py in __init__(self, filepath_or_buffer) 19 err_msg = "Install xlrd >= 1.0.0 for Excel support" 20 import_optional_dependency("xlrd", extra=err_msg) ---> 21 super().__init__(filepath_or_buffer) 22 23 @property ~\Miniconda3\lib\site-packages\pandas\io\excel\_base.py in __init__(self, filepath_or_buffer) 351 self.book = self.load_workbook(filepath_or_buffer) 352 elif isinstance(filepath_or_buffer, str): --> 353 self.book = self.load_workbook(filepath_or_buffer) 354 elif isinstance(filepath_or_buffer, bytes): 355 self.book = self.load_workbook(BytesIO(filepath_or_buffer)) ~\Miniconda3\lib\site-packages\pandas\io\excel\_xlrd.py in load_workbook(self, filepath_or_buffer) 34 return open_workbook(file_contents=data) 35 else: ---> 36 return open_workbook(filepath_or_buffer) 37 38 @property ~\Miniconda3\lib\site-packages\xlrd\__init__.py in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows) 109 else: 110 filename = os.path.expanduser(filename) --> 111 with open(filename, "rb") as f: 112 peek = f.read(peeksz) 113 if peek == b"PK\x03\x04": # a ZIP file OSError: [Errno 22] Invalid argument: '\u202aC:\\Users\\Francesco\\Desktop\\GESTIONALE.xlsx'