Forum Discussion

sreekanth332's avatar
sreekanth332
New Contributor
8 years ago

Unable read excel file with xlrd package

Hi: I wrote a code in python to read excel file (.xlsx).   Used the import package xlrd. Placed the appropriate package in C:\Program Files (x86)\SmartBear\TestComplete 11\Bin\Extensions\Python\Pyt...
baxatob's avatar
baxatob
Community Hero
8 years ago

Hi,

 

Did you receive any error?

 

Try to add a path to your package:

 

from os import sys

sys.path.insert(0, '%PATH_TO_PYTHON_DIRECTORY%\Lib\site-packages')
sreekanth332's avatar
sreekanth332
New Contributor
8 years ago

Hi Baxatob:

 

Yes  Iam receiving an error 

 

AttributeError 'module' object has no attribute 'load_workbook' Error location: Unit: "pythoncode\pythonworks\Script\Unit1" Line: 39 Column: 1.

AttributeError
'module' object has no attribute 'load_workbook'


 

THanks for your help adding the python path helps with execution of code.

 

But do i have to install Python in all system where i execute the Test Complete Code. 

I have few systems with Test Execute and I don't have Python IDLE installed there.