Forum Discussion

sreekanth332's avatar
sreekanth332
New Contributor
7 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...
sreekanth332's avatar
sreekanth332
New Contributor

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.

 

 

baxatob's avatar
baxatob
Community Hero
7 years ago

Hi,

 

Glad to hear that it helps.


You don't need to install Python, because TestComplete/TestExecute already go with Python interpreter. However you need to install your third-party package. Usually we do it using pip-installer, which is a part of a standard Python installation. But pip is not included into TC/TE installation.

 

So you can:
- automatically install the standard Python with pip module, then install your package using 'pip install' command, and finally assign the system path to it;
- manually install pip in TC/TE Python directory, then automatically install your package using 'pip install' command;
- manually install your package in TC/TE Python directory.

 

[!] Manual installation of Python libraries is not trivial and requires some attention and understanding of what you do, but all of these procedures are well documented - https://docs.python.org/3/install/