Forum Discussion

PythonAndTC's avatar
PythonAndTC
Occasional Contributor
7 years ago
Solved

Third Party Python Modules For Excel Read

We've been trying to implement use of third party python modules in TestComplete but we're running into everyone's issues in compatibility with TC and external Python modules.  At this point, we are running into issue that on secondary run that "import failed with 'NoneType' object is not callable." (https://community.smartbear.com/t5/TestComplete-General-Discussions/Python-fail-to-import-lib-during-the-second-attempt-to-run/td-p/153683).

 

We've been trying to import module xlwings that requires a module name win32api .  It seems that TestComplete has issues running this module.  We've follow all the install instructions on the forums but we can't seem to get the excel module to work.  Has anyone been able to intergrate win32api with their TestComplete code successfully?

 

Edit: We are performing more dynamic tests than bellow including using the COM server for find, createworkbook, etc.  Sample code was in Python but Python code took 15 minutes compare to VB which took 1 minute to read a 1375 line workbook)