Forum Discussion

vikram_u_k's avatar
vikram_u_k
Contributor
9 years ago
Solved

How do i add Python Libraries and extend the Pyton support on TestComplete with Python 3.0 (TC11.31)

How do i add Python Libraries and extend the Pyton support on TestComplete with Python 3.0 (TC11.31). I note that the Python executable on folder C:\Program Files\SmartBear\TestComplete 11\Bin\Exten...
SanM's avatar
SanM
Occasional Contributor
8 years ago
Copy Link

Hi,

 

I copied the custom packages to TestComplete path "C:\Program Files\SmartBear\TestComplete 11\Bin\Extensions\Python\Python34\Lib" as attached in the screen shot.

 

After this, I am using below syntax to import 

 

import openpyxl

 

But same error exist no module named 'openpyxml'.

  • baxatob's avatar
    baxatob
    Community Hero
    8 years ago
    Copy Link

     Hi!

     

    NO! You can't just copy/paste your packages!

    Copy/paste will work only for simple libraries stored in .py files. Openpyxl is more complex thing.

     

    Follow this code:

     

     

    from os import sys

'''USE YOUR OWN SETTINGS FOR PACKAGES NAMES AND LOCATIONS'''
    
openpyxl_location = "C:\\Python36\\Lib\\site-packages\\openpyxl-2.5.0a1-py3.6.egg" 
jdcal_location = "C:\\Python36\\Lib\\site-packages\\jdcal-1.3-py3.6.egg" 
etxmlfile_location = "C:\\Python36\\Lib\\site-packages\\et_xmlfile-1.0.1-py3.6.egg" 

sys.path.insert(0, openpyxl_location)
sys.path.insert(0, jdcal_location)
sys.path.insert(0, etxmlfile_location)

#Now you can do it:

from openpyxl import Workbook

# etc...