win32com and numpy

[Mauro b]

I am trying to use Excel as the front end for some python code.

I get an error (below) when trying to use a python code including numpy. If I don't import numpy I do not get the error. Is win32 somehow incompatible with numpy? I would appreciate any information regarding this issue.


Minimal example:

import win32com.server.register
import pythoncom
from numpy import mean
 
class TimeSeriesManipulation:
    _public_methods_ = [ 'SplitString']
    _reg_progid_ = "PythonUtils.NumpyError"
    _reg_clsid_ = "{08A4D1F8-0185-4692-BE40-4AD081DB90B1}"
 
 
    def SplitString(self, val, item=None):
        from string import split
        if item != None: item = str(item)
        return split(str(val), item)
 
if __name__=='__main__':
    print "Registering COM server..."
    import win32com.server.register
  win32com.server.register.UseCommandLine(TimeSeriesManipulation)
 
 

Sub tt()
Set PythonUtils = CreateObject("PythonUtils.NumpyError")
response = PythonUtils.SplitString("Hello from VB")
For Each Item In response
MsgBox Item
Next
End Sub
 

I get a run-time error ' -21474677259(80004005)':

Unexpected Python Error: Traceback (most recent call last):
File "C:\appl\python26\lib\site-packages\win32com\server\policy.py",
line 136 in CreateInstance
return retObj._CreateInstance_(clsid, reqIID)
File "C:\appl\python26\lib\site-packages\win32com\server\policy.py",
line 194, in _CreateInstance_
mvob = call func(classSpec)

[dwblas]

line 194, in _CreateInstance_
mvob = call func(classSpec)

This line in not in the code you posted so it is difficult to tell. Note that the Numpy that you install has to match the Python version. So there are separate Numpy packages for Python2.5, 2.6, and 2.7.

[Mauro b]

To clarify:
Importing any function from numpy triggers an error when using the com object in excel. If I do not import anything from numpy, I do not get any errors.