Excel file not opening in Jupyter lab and jupyter notebook

user_13514582 0
Viewed 1179

enter image description here

I could not open my excel file in jupter lab

Also when i tried to open file in jupyter notebook using dataframe its showing file not found.

jupyter-notebook excel
2 Answers

Open it using excel and save it as a csv file. Then you can open the file. The excel format is not supported to jupyter lab that's why it is not opening. You have to convert it to UTF-8 comma delimited format to be able to read in jupyter lab

user_78760860

You might consider using a 3rd party plugin such as this one to view .xlsx files:

https://github.com/quigleyj97/jupyterlab-spreadsheet

Installing is simple:

jupyter labextension install jupyterlab-spreadsheet

Then refresh/reload the JupyterLab browser window

user_97925940
Related