Problems downloading scipy via PyXLL - Has anyone succeeded in downloading scipy via PyXLL?

Question

I am using Python 2.6, Excel 2007 Professional and the latest version of PyXLL. When loading a module in PyXLL with

import scipy 

An exception is thrown and the module does not load. Could anyone upload Scipy to PyXLL? Could this be a problem with the version? The exception is:

 2010-12-21 17:21:30,915 - ERROR : Error importing 'options': DLL load failed: A dynamic link library (DLL) initialization routine failed. 2010-12-21 17:21:30,915 - ERROR : Traceback (most recent call last): 2010-12-21 17:21:30,915 - ERROR : File "pyxll", line 402, in _open 2010-12-21 17:21:30,915 - ERROR : File "C:\Dev\libs\pyxll\examples\options.py", line 15, in <module> 2010-12-21 17:21:30,915 - ERROR : import scipy 2010-12-21 17:21:30,915 - ERROR : File "C:\Python26\lib\site-packages\scipy\__init__.py", line 78, in <module> 2010-12-21 17:21:30,915 - ERROR : from numpy import show_config as show_numpy_config 2010-12-21 17:21:30,915 - ERROR : File "C:\Python26\lib\site-packages\numpy\__init__.py", line 138, in <module> 2010-12-21 17:21:30,915 - ERROR : import add_newdocs 2010-12-21 17:21:30,915 - ERROR : File "C:\Python26\lib\site-packages\numpy\add_newdocs.py", line 9, in <module> 2010-12-21 17:21:30,930 - ERROR : from lib import add_newdoc 2010-12-21 17:21:30,930 - ERROR : File "C:\Python26\lib\site-packages\numpy\lib\__init__.py", line 4, in <module> 2010-12-21 17:21:30,930 - ERROR : from type_check import * 2010-12-21 17:21:30,930 - ERROR : File "C:\Python26\lib\site-packages\numpy\lib\type_check.py", line 8, in <module> 2010-12-21 17:21:30,930 - ERROR : import numpy.core.numeric as _nx 2010-12-21 17:21:30,930 - ERROR : File "C:\Python26\lib\site-packages\numpy\core\__init__.py", line 5, in <module> 2010-12-21 17:21:30,930 - ERROR : import multiarray 2010-12-21 17:21:30,930 - ERROR : ImportError: DLL load failed: A dynamic link library (DLL) initialization routine failed. 

Answer 1

I suspect this is because you are using the NumPy Enthought distribution. The current version has a problem, which means that it cannot be embedded in Excel.

To fix this, you need to remove manifest resources from pyd numpy files using cff explorer or any other PE editor.

Enthought are aware of this and are considering the problem.

The version you can download from the numpy site works great with PyXLL.

If you have other problems, feel free to contact by email: [e-mail] or post on the PyXLL forum.

Hello,

Tony