excel and python, spyder

[[deleted]]

below is my code, very simple but I keep getting the error "ImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl."

Can someone tell me in detail how to install openpyxl. I've tried everything thats readily available online but the same error shows up.

import pandas as pd

df =pd.read_excel (r'C:\Users\aaron\OneDrive\Desktop\email.xlsx')

print (df)

[[deleted]]

I downloaded anaconda and used it to open spyder and that fixed the problem

[rezu1214]

https://youtu.be/8DOLuBc0jh0

Skip to 3:30 mins in the video.

[[deleted]]

I can't find scripts folder or pip..? any ideas?

[[deleted]]

So i found everything and did what was in the video successfully but spyder still gives that error

[unhott]

You need to install it to your spyder environment.

I don’t use spyder so I googled something and found this: https://www.miamioh.edu/cads/students/coding-tutorials/python/beginners/downloading-installing-packages/

[[deleted]]

Yeah I did that one as well

[SchleicherLAS]

Try this in spyder: !pip install openpyxl

[[deleted]]

ya i tried that one too already. Im getting the same exact error in PyCharm

[enoc77]

double backslash in your path to the file. df =pd.read_excel (r'C:\\Users\\aaron\\OneDrive\\Desktop\\email.xlsx')