" read xlsx file " [Errno 22] Invalid argument

Question

I'm trying to read An excel sheet "temp.xslx"

my code is :

temp =pd.read_excel("D:\temp.xlsx")

the error I get :

OSError: [Errno 22] Invalid argument: 'D:\temp.xlsx'

I googled the error but I got the same error over and over

https://stackoverflow.com/questions/64730768/invalid-argument-in-pd-read-excel — Joe Ferndz, Jan 17 '21 at 19:31
https://stackoverflow.com/questions/46683423/python-3-5-oserror-errno-22-invalid-argument-e-python-sales-prog-nacenk/46683717 — Joe Ferndz, Jan 17 '21 at 19:32

score 0 · Answer 1 · answered Jan 17 '21 at 19:20

0

Try pd.read_excel("D:\\temp.xlsx") or pd.read_excel(r"D:\temp.xlsx")

answered Jan 17 '21 at 19:20

Punker

1 Answers1