IOError: [Errno 2] No such file or directory: u'C:Python27ExcelBook.xls'

Question

I am just trying to write in the excel sheet 'Hello'.

Getting the following error:

IOError: [Errno 2] No such file or directory: u'C:Python27ExcelBook.xls'

Open Excel            C:\Python27\ExcelBook.xls
Put String To Cell    Sheet1  0    0     Hello
Save Excel            C:\Python27\ExcelBook.xls

This is the correct path but not sure where the 'u' coming from...

score 2 · Answer 1 · answered Jul 13 '18 at 20:02

2

Take a close look at the error:

No such file or directory: u'C:Python27ExcelBook.xls'

Notice that the error says C:Python27..., not C:\Python27\...

Robot uses the backslash as an escape character, so when you do C:\Python27\ExcelBook.xls, all the keyword sees is C:Python27ExcelBook.xls.

Use forward slashes, or use double-backslashes.

Open Excel C:\\Python27\\ExcelBook.xls

-or-

Open Excel C:/Python27/ExcelBook.xls

This is covered in the user guide, in a section titled Escaping

answered Jul 13 '18 at 20:02

Bryan Oakley

Thank you Bryan for replying. I think they did not work for me. When I try C:\\Python27\\ExcelBook.xls the out put is: IOError: [Errno 2] No such file or directory: u'C:\\Python27\\ExcelBook.xls' When I try C:/Python27/ExcelBook.xls, the output is: IOError: [Errno 2] No such file or directory: u'C:/Python27/ExcelBook.xls' I think the latter solution looks better but the 'u' is puzzling to me. Not sure if I am doing anything else wrong. – Jahid Ullah Jul 14 '18 at 02:01

score 1 · Answer 2 · answered Jul 13 '18 at 19:51

1

The u'some_text' is to indicate it is a unicode string [What's the u prefix in a Python string?. Maybe try opening with something like:

filename = str(whatEverYourStringNameWas)
# open...
# or:
filename = bytes(whateverYourStringNameWas, 'ASCII')
# open...

answered Jul 13 '18 at 19:51

bowzerfood

Thank you for your reply. I am sorry I am new to RIDE robot framework and not sure how I can implement above solution. Will you please elaborate. Thanks! – Jahid Ullah Jul 14 '18 at 02:09

score 1 · Answer 3 · answered Oct 08 '18 at 05:34

1

Yes it works double backslash, in case not working please change the file excess by right clicking on the file in advance section.

answered Oct 08 '18 at 05:34

Vijay Kumar Soni

3 Answers3