.

[Issue : Solved] Importing test library 'ExcelLibrary' failed: ImportError: No module named xlrd


Issue : Error while importing ExcelLibrary in ride editor to automate excel read/write operations.

Traceback (most recent call last):
Importing test library 'ExcelLibrary' failed: ImportError: No module named xlrd
Traceback (most recent call last):
  File "C:\Python27\lib\site-packages\ExcelLibrary\__init__.py", line 17, in <module>
    from ExcelLibrary import ExcelLibrary
  File "C:\Python27\lib\site-packages\ExcelLibrary\ExcelLibrary.py", line 22, in <module>
    from xlrd import open_workbook, cellname, xldate_as_tuple, \
PYTHONPATH:
  C:\Python27\lib\site-packages\robotide\lib\robot\libraries
  C:\Python27\lib\site-packages\robotide\lib
  C:\Python27\lib\site-packages\wx-2.8-msw-unicode
  C:\Python27\lib\site-packages\wx-2.8-msw-unicode
  C:\Python27\Scripts
  C:\Python27\lib\site-packages\xlutils-1.7.1-py2.7.egg
  C:\Python27\lib\site-packages\xlwt-1.0.0-py2.7.egg
  C:\Python27\lib\site-packages\natsort-3.3.0-py2.7.egg
  C:\Windows\system32\python27.zip
  C:\Python27\DLLs
  C:\Python27\lib
  C:\Python27\lib\plat-win
  C:\Python27\lib\lib-tk
  C:\Python27
  C:\Python27\lib\site-packages
  .

Solution: Install xlrd using this command:

pip install xlrd

No comments :

Post a Comment

Recent Posts