path = input("Enter the path")
book = xlrd.open_workbook(path)
After giving path and running program, I am getting the following error:
OSError: [Errno 22] Invalid argument: '"D:\\\shreyatest1.xlsx"'
Path is: "D:\\shreyatest1.xlsx"
Asked
Active
Viewed 140 times
1
Mureinik
- 297,002
- 52
- 306
- 350
Shreya Gaddam
- 33
- 1
- 8
-
2Are you inputting it with double slashes? – Vikas Ojha Jun 03 '16 at 12:44
-
Yes. And yet i am getting the error. – Shreya Gaddam Jun 03 '16 at 12:44
-
1Dont do that, while inputting, use single slash only. – Vikas Ojha Jun 03 '16 at 12:45
-
No luck :\ same error – Shreya Gaddam Jun 03 '16 at 12:46
-
Have you tried @Mureinik answer? That is what I meant. – Vikas Ojha Jun 03 '16 at 12:47
-
Then what did you try as a second attempt after my comment, which didnt work. – Vikas Ojha Jun 03 '16 at 12:49
-
I removed one slash and used only single slash. Which didn't work. It works when I input the path as it is and not in quotes. – Shreya Gaddam Jun 03 '16 at 12:52
-
So, another lesson to learn is that you never input something to input() in quotes, otherwise even the quotes will be considered as part of the string inputted. – Vikas Ojha Jun 03 '16 at 12:57
-
Yess. Thank you for making me realise that! – Shreya Gaddam Jun 03 '16 at 16:50
1 Answers
1
The \\ character is how python represents an escaped \ in a string literal. When inputting a string from the console, there's no need (read: it's wrong) to use this notation. Just input the path as you see it - D:\shreyatest1.xlsx.
Mureinik
- 297,002
- 52
- 306
- 350