Sikuli : XLRD - AttributeError: 'module' object has no attribute 'open_workbook

Asked by Anne

Sikuli X -1.0rc3(r905)
Python -3.3.2 amd 64
System : Win7 64
Xlrd3 -0.1.4

I have copy the FOLDER xlrd contained in the downloaded stuff to C:\Program Files\Sikuli X\Lib
so you get the following structure:

C:\Program Files\Sikuli X\Lib
  -- xlrd
      -- __init__.py
      -- ... the other .py modules

Not sure still am getting AttributeError: 'module' object has no attribute 'open_workbook'

[error] Stopped
[error] An error occurs at line 3
[error] Error message: Traceback (most recent call last):
 File "C:\Users\aliu1\AppData\Local\Temp\sikuli-tmp755480296397359463.py", line 3, in
 book=xlrd3.open_workbook("C:\\test.xls")
AttributeError: 'module' object has no attribute 'open_workbook'

is it building environment problem?

Question information

Language:
English Edit question
Status:
Solved
For:
SikuliX Edit question
Assignee:
No assignee Edit question
Solved by:
RaiMan
Solved:
Last query:
Last reply:
Revision history for this message
RaiMan (raimund-hocke) said :
#1

your setup seems ok.

book=xlrd3.open_workbook("C:\\test.xls")

you have to check, wether the use of xlrd3 is correct (the error says, that xlrd3 does not have a name open_workbook defined in it)

Revision history for this message
Anne (lhwanne) said :
#2

I chage use xlrd version and install ,not xlrd3. Others don't change , I can run successfully.

Revision history for this message
Anne (lhwanne) said :
#3

RaiMan ,Thank you very much!
By the way ,How to use Sikuli to generate result report?

Revision history for this message
Best RaiMan (raimund-hocke) said :
#4

-at- comment #3
if you want result reports, you have to use some unit testing tool.

see: faq 1804

Revision history for this message
Anne (lhwanne) said :
#5

Thanks RaiMan, that solved my question.