← Back to team overview

sikuli-driver team mailing list archive

[Question #659520]: Unable to open excel worksheet with open_workbook command in Sikuli

 

New question #659520 on Sikuli:
https://answers.launchpad.net/sikuli/+question/659520

I have performed the below steps before I could actually used the open_workbook:

1. downloaded package xlrd and unzipped it in the desired location

2. imported it by using:
dir_xlrd = "C:\\Users\\RJ043486\\SIKULI\\Lib\\xlrd\\dist\\xlrd-1.1.0\\xlrd"
if not dir_xlrd in sys.path: sys.path.append(dir_xlrd)
import xlrd

book = xlrd.open_workbook(r'C:\UserNameTEST.xls')



My problem is, even though I'm giving the exact location where I have saved the excel sheet, it still throws me error:
[error] script [ WorkBench ] stopped with error in line 7
[error] IOError ( (2, 'No such file or directory', 'C:\\UserNameTEST.xls') )
[error] --- Traceback --- error source first line: module ( function ) statement 394: __init__ ( open_workbook ) IOError: (2, 'No such file or directory', 'C:\\UserNameTEST.xls')
[error] --- Traceback --- end --------------

I have even tried: 
book = xlrd.open_workbook(C:\\UserNameTEST.xls) 

it gave me the same error too.

Please help me with this.



-- 
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.