Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

numpy 1.15.2 throw import error within anaconda python 3.7 distribution #10205

Closed
timeregained opened this issue Oct 16, 2018 · 10 comments
Closed

Comments

@timeregained
Copy link

timeregained commented Oct 16, 2018

Actual Behavior

numpy cannot be imported exclude in anaconda prompt, in other shell like cmd or powershell, it throw an import error as:

C:\Users\someone\AppData\Local\Continuum\miniconda3\python.exe -c "import numpy; numpy.test()"
Traceback (most recent call last):
File "C:\Users\jti\AppData\Local\Continuum\miniconda3\lib\site-packages\numpy\core_init_.py", line 16, in
from . import multiarray
ImportError: DLL load failed: The specified module could not be found.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "", line 1, in
File "C:\Users\jti\AppData\Local\Continuum\miniconda3\lib\site-packages\numpy_init_.py", line 142, in
from . import add_newdocs
File "C:\Users\jti\AppData\Local\Continuum\miniconda3\lib\site-packages\numpy\add_newdocs.py", line 13, in
from numpy.lib import add_newdoc
File "C:\Users\jti\AppData\Local\Continuum\miniconda3\lib\site-packages\numpy\lib_init_.py", line 8, in
from .type_check import *
File "C:\Users\jti\AppData\Local\Continuum\miniconda3\lib\site-packages\numpy\lib\type_check.py", line 11, in
import numpy.core.numeric as nx
File "C:\Users\jti\AppData\Local\Continuum\miniconda3\lib\site-packages\numpy\core_init
.py", line 26, in
raise ImportError(msg)
ImportError:
Importing the multiarray numpy extension module failed. Most
likely you are trying to import a failed build of numpy.
If you're working with a numpy git repo, try git clean -xdf (removes all
files not under version control). Otherwise reinstall numpy.

Original error was: DLL load failed: The specified module could not be found.

Note: Anaconda recommend not to add the path to the system environment variable , so I need to use absolute python path.

This issue affects xlwings projects, any scripts import numpy would through the same import error when calling in excel.

Expected Behavior

numpy could be imported as normal as before.

Steps to Reproduce

I have tested in 3 different pc, one PC is installed windows 10 1809, other 2 is windows 10 1709, all of them repeated the issue as the same.

I have tried to downgrade numpy to 1.15.1 but it perform the same, however, another pc with python 3.6.6 is not affected by this issue.(python 3.6.6 hea74fb7_0;numpy 1.15.2 py36ha559c80_0)

I also tired to remove numpy from anaconda and install numpy with pip instead, it shows the pip version numpy(numpy-1.15.2-cp37-none-win_amd64.whl) does not have this issue.

Anaconda or Miniconda version:

anaconda custom py37_0

Operating System:

Windows 10 x64 1709.

conda info
     active environment : base
    active env location : C:\Users\someone\AppData\Local\Continuum\miniconda3
            shell level : 1
       user config file : C:\Users\someone\.condarc
 populated config files : C:\Users\someone\.condarc
          conda version : 4.5.11
    conda-build version : not installed
         python version : 3.7.0.final.0
       base environment : C:\Users\someone\AppData\Local\Continuum\miniconda3  (writable)
           channel URLs : https://repo.anaconda.com/pkgs/main/win-64
                          https://repo.anaconda.com/pkgs/main/noarch
                          https://repo.anaconda.com/pkgs/free/win-64
                          https://repo.anaconda.com/pkgs/free/noarch
                          https://repo.anaconda.com/pkgs/r/win-64
                          https://repo.anaconda.com/pkgs/r/noarch
                          https://repo.anaconda.com/pkgs/pro/win-64
                          https://repo.anaconda.com/pkgs/pro/noarch
                          https://repo.anaconda.com/pkgs/msys2/win-64
                          https://repo.anaconda.com/pkgs/msys2/noarch
                          https://conda.anaconda.org/intel/win-64
                          https://conda.anaconda.org/intel/noarch
          package cache : C:\Users\someone\AppData\Local\Continuum\miniconda3\pkgs
                          C:\Users\someone\AppData\Local\conda\conda\pkgs
       envs directories : C:\Users\someone\AppData\Local\Continuum\miniconda3\envs
                          C:\Users\someone\AppData\Local\conda\conda\envs
                          C:\Users\someone\.conda\envs
               platform : win-64
             user-agent : conda/4.5.11 requests/2.19.1 CPython/3.7.0 Windows/10 Windows/10.0.16299
          administrator : False
             netrc file : None
           offline mode : False
conda list --show-channel-urls
# packages in environment at C:\Users\someone\AppData\Local\Continuum\miniconda3:
#
# Name                    Version                   Build  Channel
_r-mutex                  1.0.0                     mro_2    defaults
agate                     1.6.1                    py37_2    defaults
alabaster                 0.7.12                   py37_0    defaults
anaconda                  custom                   py37_0    defaults
anaconda-client           1.7.2                    py37_0    defaults
anaconda-navigator        1.9.2                    py37_0    defaults
anaconda-project          0.8.2                    py37_0    defaults
anyqt                     0.0.10                   py37_0    defaults
appdirs                   1.4.3            py37h28b3542_0    defaults
asn1crypto                0.24.0                   py37_0    defaults
astroid                   2.0.4                    py37_0    defaults
astropy                   3.0.4            py37hfa6e2cd_0    defaults
atomicwrites              1.2.1                    py37_0    defaults
attrs                     18.2.0           py37h28b3542_0    defaults
automat                   0.7.0                    py37_0    defaults
autopep8                  1.4                      py37_0    defaults
babel                     2.6.0                    py37_0    defaults
backcall                  0.1.0                    py37_0    defaults
backports                 1.0                      py37_1    defaults
backports.functools_lru_cache 1.5                        py_1    conda-forge
backports.shutil_get_terminal_size 1.0.0                    py37_2    defaults
beautifulsoup4            4.6.3                    py37_0    defaults
bitarray                  0.8.3            py37hfa6e2cd_0    defaults
bkcharts                  0.2                      py37_0    defaults
blas                      1.0                         mkl    defaults
blaze                     0.11.3                   py37_0    defaults
bleach                    3.0.2                    py37_0    defaults
blosc                     1.14.4               he51fdeb_0    defaults
bokeh                     0.13.0                   py37_0    defaults
boto                      2.49.0                   py37_0    defaults
bottleneck                1.2.1            py37h452e1ab_1    defaults
bzip2                     1.0.6                hfa6e2cd_5    defaults
ca-certificates           2018.03.07                    0    defaults
cachecontrol              0.12.5                   py37_0    defaults
certifi                   2018.10.15               py37_0    defaults
cffi                      1.11.5           py37h74b6da3_1    defaults
chardet                   3.0.4                    py37_1    defaults
click                     7.0                      py37_0    defaults
cloudpickle               0.6.1                    py37_0    defaults
clyent                    1.2.2                    py37_1    defaults
colorama                  0.4.0                    py37_0    defaults
commonmark                0.8.1                    py37_0    defaults
comtypes                  1.1.7                    py37_0    defaults
conda                     4.5.11                   py37_0    defaults
conda-env                 2.6.0                         1    defaults
console_shortcut          0.1.1                         3    defaults
constantly                15.1.0           py37h28b3542_0    defaults
contextlib2               0.5.5                    py37_0    defaults
coverage                  4.5.1            py37hfa6e2cd_0    defaults
cryptography              2.3.1            py37h74b6da3_0    defaults
cryptography-vectors      2.3.1                    py37_0    defaults
cudatoolkit               9.0                           1    defaults
cudnn                     7.1.4                 cuda9.0_0    defaults
curl                      7.61.1               h7602738_0    defaults
cycler                    0.10.0                   py37_0    defaults
cython                    0.29             py37ha925a31_0    defaults
cytoolz                   0.9.0.1          py37hfa6e2cd_1    defaults
dask                      0.19.4                   py37_0    defaults
dask-core                 0.19.4                   py37_0    defaults
datashape                 0.5.4                    py37_1    defaults
decorator                 4.3.0                    py37_0    defaults
dill                      0.2.8.2                  py37_0    defaults
distlib                   0.2.8                    py37_0    defaults
distributed               1.23.3                   py37_0    defaults
django                    2.1.2                    py37_0    defaults
docutils                  0.14                     py37_0    defaults
entrypoints               0.2.3                    py37_2    defaults
et_xmlfile                1.0.1                    py37_0    defaults
fast-histogram            0.5              py37h452e1ab_1    defaults
fastcache                 1.0.2            py37hfa6e2cd_2    defaults
fastrlock                 0.4              py37h6538335_0    defaults
filelock                  3.0.9                    py37_0    defaults
flask                     1.0.2                    py37_1    defaults
flask-cors                3.0.6                    py37_0    defaults
font-ttf-dejavu-sans-mono 2.37                 h6964260_0    defaults
font-ttf-inconsolata      2.001                hcb22688_0    defaults
font-ttf-source-code-pro  2.030                h7457263_0    defaults
font-ttf-ubuntu           0.83                 h8b1ccd4_0    defaults
fonts-anaconda            1                    h8fa9717_0    defaults
freetype                  2.9.1                ha9979f8_1    defaults
future                    0.16.0                   py37_0    defaults
get_terminal_size         1.0.0                h38e98db_0    defaults
gevent                    1.3.7            py37he774522_0    defaults
glob2                     0.6                      py37_1    defaults
glpk                      4.65                 hdc00fd2_2    defaults
glue-core                 0.13.3                   py37_0    defaults
glue-vispy-viewers        0.10                     py37_0    defaults
glueviz                   0.13.3                        0    defaults
greenlet                  0.4.15           py37hfa6e2cd_0    defaults
gsl                       2.4                  hfa6e2cd_4    defaults
h5py                      2.8.0            py37h3bdd7fb_2    defaults
hdf5                      1.10.2               hac2f561_1    defaults
heapdict                  1.0.0                    py37_2    defaults
holoviews                 1.10.6                   py37_0    defaults
html5lib                  1.0.1                    py37_0    defaults
hyperlink                 18.0.0                   py37_0    defaults
hypothesis                3.59.1           py37h39e3cac_0    defaults
icc_rt                    2017.0.4             h97af966_0    defaults
icu                       58.2                 ha66f8fd_1    defaults
idna                      2.7                      py37_0    defaults
imageio                   2.4.1                    py37_0    defaults
imagesize                 1.1.0                    py37_0    defaults
incremental               17.5.0                   py37_0    defaults
intel-openmp              2019.0                      118    defaults
ipykernel                 5.0.0            py37h39e3cac_0    defaults
ipython                   7.0.1            py37h39e3cac_0    defaults
ipython_genutils          0.2.0                    py37_0    defaults
ipywidgets                7.4.2                    py37_0    defaults
isodate                   0.6.0                    py37_0    defaults
isort                     4.3.4                    py37_0    defaults
itsdangerous              0.24                     py37_1    defaults
jdcal                     1.4                      py37_0    defaults
jedi                      0.13.1                   py37_0    defaults
jinja2                    2.10                     py37_0    defaults
joblib                    0.12.5                   py37_0    defaults
jpeg                      9b                   hb83a4c4_2    defaults
jsonschema                2.6.0                    py37_0    defaults
jupyter                   1.0.0                    py37_7    defaults
jupyter_client            5.2.3                    py37_0    defaults
jupyter_console           6.0.0                    py37_0    defaults
jupyter_core              4.4.0                    py37_0    defaults
jupyterlab                0.35.0                   py37_0    defaults
jupyterlab_launcher       0.13.1                   py37_0    defaults
jupyterlab_server         0.2.0                    py37_0    defaults
keyring                   15.1.0                   py37_0    defaults
keyrings.alt              3.1                      py37_0    defaults
kiwisolver                1.0.1            py37h6538335_0    defaults
krb5                      1.16.1               h038dc86_6    defaults
lazy-object-proxy         1.3.1            py37hfa6e2cd_2    defaults
leather                   0.3.3                    py37_0    defaults
libcurl                   7.61.1               h7602738_0    defaults
libgpuarray               0.7.6                hfa6e2cd_0    defaults
libiconv                  1.15                 h1df5818_7    defaults
libopencv                 3.4.1                h875b8b8_3    defaults
libpng                    1.6.34               h79bbb47_0    defaults
libpython                 2.1                      py37_0    defaults
libsodium                 1.0.16               h9d3ae62_0    defaults
libssh2                   1.8.0                hd619d38_4    defaults
libtiff                   4.0.9                h36446d0_2    defaults
libxml2                   2.9.8                hadb2253_1    defaults
libxslt                   1.1.32               hf6f1972_0    defaults
llvmlite                  0.25.0                   py37_0    defaults
locket                    0.2.0                    py37_1    defaults
lockfile                  0.12.2                   py37_0    defaults
lxml                      4.2.5            py37hef2cd61_0    defaults
lzo                       2.10                 h6df0209_2    defaults
m2-bash                   4.3.042                       5    defaults
m2-gcc-libs               5.3.0                         4    defaults
m2-heimdal                1.5.3                        10    defaults
m2-heimdal-libs           1.5.3                        10    defaults
m2-icu                    56.1                          2    defaults
m2-libcrypt               1.3                           2    defaults
m2-libdb                  5.3.28                        3    defaults
m2-libedit                3.1                    20150326    defaults
m2-libopenssl             1.0.2.g                       2    defaults
m2-libreadline            6.3.008                       8    defaults
m2-libsqlite              3.10.0.0                      2    defaults
m2-msys2-runtime          2.5.0.17080.65c939c               3    defaults
m2-ncurses                6.0.20160220                  2    defaults
m2-openssh                7.1p2                         2    defaults
m2-openssl                1.0.2.g                       2    defaults
m2-zlib                   1.2.8                         4    defaults
m2w64-binutils            2.25.1                        5    defaults
m2w64-bwidget             1.9.10                        2    defaults
m2w64-bzip2               1.0.6                         6    defaults
m2w64-c-ares              1.11.0                        2    defaults
m2w64-ca-certificates     20150426                    103    defaults
m2w64-crt-git             5.0.0.4636.2595836               2    defaults
m2w64-curl                7.48.0                        2    defaults
m2w64-diffutils           3.3.2                         2    defaults
m2w64-expat               2.1.1                         2    defaults
m2w64-fftw                3.3.4                         6    defaults
m2w64-flac                1.3.1                         3    defaults
m2w64-gcc                 5.3.0                         6    defaults
m2w64-gcc-ada             5.3.0                         6    defaults
m2w64-gcc-fortran         5.3.0                         6    defaults
m2w64-gcc-libgfortran     5.3.0                         6    defaults
m2w64-gcc-libs            5.3.0                         7    defaults
m2w64-gcc-libs-core       5.3.0                         7    defaults
m2w64-gcc-objc            5.3.0                         6    defaults
m2w64-gettext             0.19.7                        2    defaults
m2w64-gmp                 6.1.0                         2    defaults
m2w64-gnutls              3.4.11                        2    defaults
m2w64-grep                2.24                          2    defaults
m2w64-gsl                 2.1                           2    defaults
m2w64-headers-git         5.0.0.4636.c0ad18a               2    defaults
m2w64-isl                 0.16.1                        2    defaults
m2w64-jansson             2.7                           3    defaults
m2w64-libffi              3.2.1                         4    defaults
m2w64-libiconv            1.14                          6    defaults
m2w64-libidn              1.32                          4    defaults
m2w64-libjpeg-turbo       1.4.2                         3    defaults
m2w64-libmangle-git       5.0.0.4509.2e5a9a2               2    defaults
m2w64-libmetalink         0.1.3                         2    defaults
m2w64-libogg              1.3.2                         3    defaults
m2w64-libpng              1.6.21                        2    defaults
m2w64-libsndfile          1.0.26                        2    defaults
m2w64-libssh2             1.7.0                         2    defaults
m2w64-libsystre           1.0.1                         3    defaults
m2w64-libtasn1            4.7                           2    defaults
m2w64-libtiff             4.0.6                         2    defaults
m2w64-libtre-git          122.c2f5d13                   5    defaults
m2w64-libvorbis           1.3.5                         2    defaults
m2w64-libwinpthread-git   5.0.0.4634.697f757               2    defaults
m2w64-libxml2             2.9.3                         4    defaults
m2w64-make                4.1.2351.a80a8b8               2    defaults
m2w64-mpc                 1.0.3                         3    defaults
m2w64-mpfr                3.1.4                         4    defaults
m2w64-nettle              3.1.1                         4    defaults
m2w64-nghttp2             1.9.2                         2    defaults
m2w64-openssl             1.0.2.g                       2    defaults
m2w64-p11-kit             0.23.2                        2    defaults
m2w64-pcre                8.38                          2    defaults
m2w64-pkg-config          0.29.1                        2    defaults
m2w64-rtmpdump-git        499.a107cef                   4    defaults
m2w64-speex               1.2rc2                        3    defaults
m2w64-speexdsp            1.2rc3                        3    defaults
m2w64-tcl                 8.6.5                         3    defaults
m2w64-tk                  8.6.5                         3    defaults
m2w64-tktable             2.10                          5    defaults
m2w64-toolchain           5.3.0                         7    defaults
m2w64-tools-git           5.0.0.4592.90b8472               2    defaults
m2w64-windows-default-manifest 6.4                           3    defaults
m2w64-wineditline         2.101                         5    defaults
m2w64-winpthreads-git     5.0.0.4634.697f757               2    defaults
m2w64-xz                  5.2.2                         2    defaults
m2w64-zlib                1.2.8                        10    defaults
mako                      1.0.7                    py37_0    defaults
markupsafe                1.0              py37hfa6e2cd_1    defaults
matplotlib                3.0.0            py37hd159220_0    defaults
mccabe                    0.6.1                    py37_1    defaults
menuinst                  1.4.14           py37hfa6e2cd_0    defaults
mistune                   0.8.4            py37he774522_0    defaults
mkl                       2019.0                      118    defaults
mkl-service               1.1.2            py37hb217b18_5    defaults
mkl_fft                   1.0.6            py37hdbbee80_0    defaults
mkl_random                1.0.1            py37h77b88f5_1    defaults
more-itertools            4.3.0                    py37_0    defaults
mpl-scatter-density       0.4                      py37_0    defaults
mpmath                    1.0.0                    py37_2    defaults
mro-base                  3.5.1                         0    defaults
mro-basics                3.5.1                         0    defaults
msgpack-python            0.5.6            py37he980bc4_1    defaults
msys2-conda-epoch         20160418                      1    defaults
multipledispatch          0.6.0                    py37_0    defaults
navigator-updater         0.2.1                    py37_0    defaults
nbconvert                 5.3.1                    py37_0    defaults
nbformat                  4.4.0                    py37_0    defaults
networkx                  2.2                      py37_1    defaults
nltk                      3.3.0                    py37_0    defaults
nodejs                    8.9.3                hd6b2f15_0    defaults
nose                      1.3.7                    py37_2    defaults
notebook                  5.7.0                    py37_0    defaults
numba                     0.40.0           py37hf9181ef_0    defaults
numexpr                   2.6.8            py37h9ef55f4_0    defaults
numpy                     1.15.2           py37ha559c80_0    defaults
numpy-base                1.15.2           py37h8128ebf_0    defaults
numpydoc                  0.8.0                    py37_0    defaults
odo                       0.5.1                    py37_0    defaults
olefile                   0.46                     py37_0    defaults
opencv                    3.4.1            py37h6fd60c2_3    defaults
openpyxl                  2.5.8                    py37_0    defaults
openssl                   1.0.2p               hfa6e2cd_0    defaults
orange3                   3.16.0           py37h830ac7b_0    defaults
packaging                 18.0                     py37_0    defaults
pandas                    0.23.4           py37h830ac7b_0    defaults
pandoc                    2.2.3.2                       0    defaults
pandocfilters             1.4.2                    py37_1    defaults
param                     1.8.1                    py37_0    defaults
parsedatetime             2.4                      py37_0    defaults
parso                     0.3.1                    py37_0    defaults
partd                     0.3.9                    py37_0    defaults
path.py                   11.1.0                   py37_0    defaults
pathlib2                  2.3.2                    py37_0    defaults
patsy                     0.5.0                    py37_0    defaults
pep8                      1.7.1                    py37_0    defaults
pickleshare               0.7.5                    py37_0    defaults
pillow                    5.3.0            py37hdc69c19_0    defaults
pip                       10.0.1                   py37_0    defaults
pipdeptree                0.13.1                    <pip>
pkginfo                   1.4.2                    py37_1    defaults
plotly                    3.3.0            py37h28b3542_0    defaults
pluggy                    0.7.1            py37h28b3542_0    defaults
ply                       3.11                     py37_0    defaults
progress                  1.4                      py37_0    defaults
prometheus_client         0.4.2                    py37_0    defaults
prompt_toolkit            2.0.6                    py37_0    defaults
psutil                    5.4.7            py37hfa6e2cd_0    defaults
py                        1.7.0                    py37_0    defaults
py-opencv                 3.4.1            py37h1b0d24d_3    defaults
pyasn1                    0.4.4            py37h28b3542_0    defaults
pyasn1-modules            0.2.2                    py37_0    defaults
pycodestyle               2.4.0                    py37_0    defaults
pycosat                   0.6.3            py37hfa6e2cd_0    defaults
pycparser                 2.19                     py37_0    defaults
pycrypto                  2.6.1            py37hfa6e2cd_9    defaults
pyculib_sorting           1.0.0                         8    defaults
pycurl                    7.43.0.2         py37h74b6da3_0    defaults
pyflakes                  2.0.0                    py37_0    defaults
PyForms                   3.0.0                     <pip>
pygame                    1.9.4                     <pip>
pygments                  2.2.0                    py37_0    defaults
pygpu                     0.7.6            py37h452e1ab_0    defaults
pylint                    2.1.1                    py37_0    defaults
pymc3                     3.5                      py37_0    defaults
pymodbus                  2.1.0                     <pip>
pympler                   0.5                      py37_0    defaults
pyodbc                    4.0.24           py37h6538335_0    defaults
pyopengl                  3.1.1a1                  py37_0    defaults
pyopenssl                 18.0.0                   py37_0    defaults
pyparsing                 2.2.2                    py37_0    defaults
pyqt                      5.9.2            py37h6538335_2    defaults
pyqtgraph                 0.10.0           py37h28b3542_3    defaults
pyreadline                2.1                      py37_1    defaults
pyserial                  3.4                      py37_0    defaults
pysocks                   1.6.8                    py37_0    defaults
pytables                  3.4.4            py37he6f6034_0    defaults
pytest                    3.8.2                    py37_0    defaults
pytest-arraydiff          0.2              py37h39e3cac_0    defaults
pytest-astropy            0.4.0                    py37_0    defaults
pytest-doctestplus        0.1.3                    py37_0    defaults
pytest-openfiles          0.3.0                    py37_0    defaults
pytest-remotedata         0.3.0                    py37_0    defaults
python                    3.7.0                hea74fb7_0    defaults
python-dateutil           2.7.3                    py37_0    defaults
python-louvain            0.11             py37h28b3542_0    defaults
python-slugify            1.2.6                    py37_0    defaults
pytimeparse               1.1.8                    py37_0    defaults
pytz                      2018.5                   py37_0    defaults
pyviz_comms               0.6.0                    py37_0    defaults
pywavelets                1.0.1            py37h8c2d366_0    defaults
pywin32                   223              py37hfa6e2cd_1    defaults
pywinpty                  0.5.4                    py37_0    defaults
PyX                       0.14.1                    <pip>
pyyaml                    3.13             py37hfa6e2cd_0    defaults
pyzmq                     17.1.2           py37hfa6e2cd_0    defaults
QScintilla                2.10.4                    <pip>
qt                        5.9.6            vc14h1e9a669_2    defaults
qtawesome                 0.5.1                    py37_1    defaults
qtconsole                 4.4.1                    py37_0    defaults
qtpy                      1.5.1                    py37_0    defaults
r                         3.5.1                  mro351_0    defaults
r-abind                   1.4_5                  mro351_0    defaults
r-assertthat              0.2.0                  mro351_0    defaults
r-backports               1.1.2                  mro351_0    defaults
r-base64enc               0.1_3                  mro351_0    defaults
r-bh                      1.66.0_1        mro351hf348343_0    defaults
r-bindr                   0.1.1                  mro351_0    defaults
r-bindrcpp                0.2.2                  mro351_0    defaults
r-bit                     1.1_14                 mro351_0    defaults
r-bit64                   0.9_7                  mro351_0    defaults
r-bitops                  1.0_6                        0a    defaults
r-blob                    1.1.1                  mro351_0    defaults
r-boot                    1.3_20                 mro351_0    defaults
r-broom                   0.5.0                  mro351_0    defaults
r-callr                   2.0.4                  mro351_0    defaults
r-caret                   6.0_80                 mro351_0    defaults
r-catools                 1.17.1.1        mro351hf348343_0    defaults
r-cellranger              1.1.0                  mro351_0    defaults
r-checkpoint              0.4.4                  mro351_0    defaults
r-class                   7.3_14                 mro351_0    defaults
r-cli                     1.0.0                  mro351_0    defaults
r-clipr                   0.4.1                  mro351_0    defaults
r-cluster                 2.0.7_1                mro351_0    defaults
r-codetools               0.2_15                 mro351_0    defaults
r-colorspace              1.3_2                  mro351_0    defaults
r-config                  0.3                    mro351_0    defaults
r-crayon                  1.3.4                  mro351_0    defaults
r-curl                    3.2                    mro351_0    defaults
r-cvst                    0.2_2           mro351hf348343_0    defaults
r-data.table              1.11.4                 mro351_0    defaults
r-dbi                     1.0.0           mro351hf348343_0    defaults
r-dbplyr                  1.2.2                  mro351_0    defaults
r-ddalpha                 1.3.4                  mro351_0    defaults
r-deoptimr                1.0_8           mro351hf348343_0    defaults
r-deployrrserve           9.0.0                  mro351_0    defaults
r-dichromat               2.0_0                  mro351_0    defaults
r-digest                  0.6.15                 mro351_0    defaults
r-dimred                  0.1.0           mro351hf348343_0    defaults
r-doparallel              1.0.13                 mro351_0    defaults
r-dplyr                   0.7.6                  mro351_0    defaults
r-drr                     0.0.3           mro351hf348343_0    defaults
r-essentials              3.5.1                  mro351_0    defaults
r-evaluate                0.11                   mro351_0    defaults
r-fansi                   0.2.3                  mro351_0    defaults
r-forcats                 0.3.0                  mro351_0    defaults
r-foreach                 1.5.0                  mro351_0    defaults
r-foreign                 0.8_70                 mro351_0    defaults
r-formatr                 1.5             mro351hf348343_0    defaults
r-geometry                0.3_6                  mro351_0    defaults
r-ggplot2                 3.0.0                  mro351_0    defaults
r-gistr                   0.4.0            r342hce11cbc_0    defaults
r-glmnet                  2.0_16                 mro351_0    defaults
r-glue                    1.3.0                  mro351_0    defaults
r-gower                   0.1.2                  mro351_0    defaults
r-gtable                  0.2.0                  mro351_0    defaults
r-haven                   1.1.2                  mro351_0    defaults
r-hexbin                  1.27.2                 mro351_0    defaults
r-highr                   0.7                    mro351_0    defaults
r-hms                     0.4.2                  mro351_0    defaults
r-htmltools               0.3.6                  mro351_0    defaults
r-htmlwidgets             1.2                    mro351_0    defaults
r-httpuv                  1.4.5                  mro351_0    defaults
r-httr                    1.3.1                  mro351_0    defaults
r-ipred                   0.9_6                  mro351_0    defaults
r-irdisplay               0.5.0           mro351hf348343_0    defaults
r-irkernel                0.8.11                 mro343_0    defaults
r-iterators               1.0.10                 mro351_0    defaults
r-jsonlite                1.5                    mro351_0    defaults
r-kernlab                 0.9_26                 mro351_0    defaults
r-kernsmooth              2.23_15         mro351hf348343_0    defaults
r-knitr                   1.20                   mro351_0    defaults
r-labeling                0.3                          0a    defaults
r-later                   0.7.3                  mro351_0    defaults
r-lattice                 0.20_35                mro351_0    defaults
r-lava                    1.6.2                  mro351_0    defaults
r-lazyeval                0.2.1                  mro351_0    defaults
r-lubridate               1.7.4                  mro351_0    defaults
r-magic                   1.5_8                  mro351_0    defaults
r-magrittr                1.5                          0a    defaults
r-maps                    3.3.0                  mro351_0    defaults
r-markdown                0.8                    mro351_0    defaults
r-mass                    7.3_49                 mro351_0    defaults
r-matrix                  1.2_14          mro351hf348343_0    defaults
r-mgcv                    1.8_23                 mro351_0    defaults
r-microsoftr              3.5.0.108              mro351_0    defaults
r-mime                    0.5                    mro351_0    defaults
r-miniui                  0.1.1.1         mro351hf348343_0    defaults
r-mnormt                  1.5_5                  mro351_0    defaults
r-modelmetrics            1.1.0           mro351hf348343_0    defaults
r-modelr                  0.1.2                  mro351_0    defaults
r-mongolite               1.6                    mro351_0    defaults
r-munsell                 0.5.0                  mro351_0    defaults
r-nlme                    3.1_137                mro351_0    defaults
r-nnet                    7.3_12                 mro351_0    defaults
r-numderiv                2016.8_1        mro351hf348343_0    defaults
r-odbc                    1.1.6                  mro351_0    defaults
r-openssl                 1.0.2                  mro351_0    defaults
r-packrat                 0.4.9_3                mro351_0    defaults
r-pbdzmq                  0.3_3           mro351hf348343_0    defaults
r-pillar                  1.3.0                  mro351_0    defaults
r-pkgconfig               2.0.1                  mro351_0    defaults
r-pki                     0.1_5.1         mro351hf348343_0    defaults
r-plogr                   0.2.0                  mro351_0    defaults
r-pls                     2.6_0                  mro351_0    defaults
r-plyr                    1.8.4                  mro351_0    defaults
r-png                     0.1_7                  mro351_0    defaults
r-praise                  1.0.0                  mro351_0    defaults
r-prettyunits             1.0.2                  mro351_0    defaults
r-processx                3.1.0                  mro351_0    defaults
r-prodlim                 2018.04.18             mro351_0    defaults
r-profvis                 0.3.5                  mro351_0    defaults
r-promises                1.0.1                  mro351_0    defaults
r-pryr                    0.1.4                  mro351_0    defaults
r-psych                   1.8.4                  mro351_0    defaults
r-purrr                   0.2.5                  mro351_0    defaults
r-quantmod                0.4_13                 mro351_0    defaults
r-r6                      2.2.2           mro351hf348343_0    defaults
r-randomforest            4.6_14          mro351hf348343_0    defaults
r-rappdirs                0.3.1                  mro351_0    defaults
r-rbokeh                  0.6.3                  mro343_0    defaults
r-rcolorbrewer            1.1_2           mro351hf348343_0    defaults
r-rcpp                    0.12.18         mro351hf348343_0    defaults
r-rcpproll                0.3.0           mro351hf348343_0    defaults
r-rcurl                   1.95_4.11       mro351hf348343_0    defaults
r-readr                   1.1.1                  mro351_0    defaults
r-readxl                  1.1.0                  mro351_0    defaults
r-recipes                 0.1.3                  mro351_0    defaults
r-recommended             3.5.1                  mro351_0    defaults
r-rematch                 1.0.1                  mro351_0    defaults
r-repr                    0.15.0                 mro351_0    defaults
r-reprex                  0.2.0                  mro351_0    defaults
r-reshape2                1.4.3                  mro351_0    defaults
r-revoioq                 10.0.0                 mro351_0    defaults
r-revomods                11.0.0                 mro351_0    defaults
r-revoutilsmath           11.0.0                 mro351_0    defaults
r-rjava                   0.9_9           mro343h889e2dd_0    defaults
r-rjdbc                   0.2_7.1         mro351hf348343_0    defaults
r-rjsonio                 1.3_0                        0a    defaults
r-rlang                   0.2.1                  mro351_0    defaults
r-rmarkdown               1.10                   mro351_0    defaults
r-robustbase              0.93_2                 mro351_0    defaults
r-rpart                   4.1_13                 mro351_0    defaults
r-rprojroot               1.3_2                  mro351_0    defaults
r-rsconnect               0.8.8                  mro351_0    defaults
r-rstudioapi              0.7                    mro351_0    defaults
r-runit                   0.4.26                 mro351_0    defaults
r-rvest                   0.3.2                  mro351_0    defaults
r-scales                  0.5.0                  mro351_0    defaults
r-selectr                 0.4_1                  mro351_0    defaults
r-sfsmisc                 1.1_2                  mro351_0    defaults
r-shiny                   1.1.0                  mro351_0    defaults
r-sourcetools             0.1.7                  mro351_0    defaults
r-sparklyr                0.8.4                  mro351_0    defaults
r-spatial                 7.3_11                 mro351_0    defaults
r-squarem                 2017.10_1       mro351hf348343_0    defaults
r-stringi                 1.1.7                  mro351_0    defaults
r-stringr                 1.3.1                  mro351_0    defaults
r-survival                2.41_3                 mro351_0    defaults
r-testthat                2.0.0                  mro351_0    defaults
r-tibble                  1.4.2                  mro351_0    defaults
r-tidyr                   0.8.1                  mro351_0    defaults
r-tidyselect              0.2.4                  mro351_0    defaults
r-tidyverse               1.2.1                  mro351_0    defaults
r-timedate                3043.102        mro351hf348343_0    defaults
r-tinytex                 0.6                    mro351_0    defaults
r-ttr                     0.23_3          mro351hf348343_0    defaults
r-utf8                    1.1.4                  mro351_0    defaults
r-uuid                    0.1_2                  mro351_0    defaults
r-viridislite             0.3.0           mro351hf348343_0    defaults
r-whisker                 0.3_2                        0a    defaults
r-withr                   2.1.2                  mro351_0    defaults
r-xfun                    0.3                    mro351_0    defaults
r-xml2                    1.2.0                  mro351_0    defaults
r-xtable                  1.8_2                  mro351_0    defaults
r-xts                     0.11_0                 mro351_0    defaults
r-yaml                    2.2.0                  mro351_0    defaults
r-zoo                     1.8_3                  mro351_0    defaults
requests                  2.19.1                   py37_0    defaults
retrying                  1.3.3                    py37_2    defaults
rope                      0.11.0                   py37_0    defaults
rstudio                   1.2.502          vc14h088ffc6_0  [vc14]  rdonnelly
ruamel_yaml               0.15.46          py37hfa6e2cd_0    defaults
rx                        1.6.1                      py_0    conda-forge
scapy                     2.4.0                     <pip>
scikit-image              0.14.0           py37h6538335_1    defaults
scikit-learn              0.20.0           py37heebcf9a_1    defaults
scipy                     1.1.0            py37h4f6bf74_1    defaults
seaborn                   0.9.0                    py37_0    defaults
send2trash                1.5.0                    py37_0    defaults
serverfiles               0.2.1                    py37_0    defaults
service_identity          17.0.0           py37h28b3542_0    defaults
setuptools                40.4.3                   py37_0    defaults
simplegeneric             0.8.1                    py37_2    defaults
singledispatch            3.4.0.3                  py37_0    defaults
sip                       4.19.8           py37h6538335_0    defaults
six                       1.11.0                   py37_1    defaults
snappy                    1.1.7                h777316e_3    defaults
snowballstemmer           1.2.1                    py37_0    defaults
sortedcollections         1.0.1                    py37_0    defaults
sortedcontainers          2.0.5                    py37_0    defaults
sphinx                    1.8.1                    py37_0    defaults
sphinxcontrib             1.0                      py37_1    defaults
sphinxcontrib-websupport  1.1.0                    py37_1    defaults
spyder                    3.3.1                    py36_1    defaults
spyder-kernels            1.0.1                    py37_0    defaults
sqlalchemy                1.2.12           py37he774522_0    defaults
sqlite                    3.25.2               hfa6e2cd_0    defaults
statsmodels               0.9.0            py37h452e1ab_0    defaults
sympy                     1.3                      py37_0    defaults
tblib                     1.3.2                    py37_0    defaults
terminado                 0.8.1                    py37_1    defaults
testpath                  0.4.2                    py37_0    defaults
theano                    1.0.3                    py37_0    defaults
tk                        8.6.8                hfa6e2cd_0    defaults
toolz                     0.9.0                    py37_0    defaults
tornado                   5.1.1            py37hfa6e2cd_0    defaults
tqdm                      4.26.0           py37h28b3542_0    defaults
traitlets                 4.3.2                    py37_0    defaults
twisted                   18.7.0           py37hfa6e2cd_1    defaults
typed-ast                 1.1.0            py37hfa6e2cd_0    defaults
typing                    3.6.4                    py37_0    defaults
unicodecsv                0.14.1                   py37_0    defaults
unidecode                 1.0.22                   py37_0    defaults
urllib3                   1.23                     py37_0    defaults
vc                        14.1                 h21ff451_3    defaults
visvis                    1.11.1                   py37_0    defaults
vs2015_runtime            15.5.2                        3    defaults
wcwidth                   0.1.7                    py37_0    defaults
webencodings              0.5.1                    py37_1    defaults
werkzeug                  0.14.1                   py37_0    defaults
wheel                     0.32.1                   py37_0    defaults
widgetsnbextension        3.4.2                    py37_0    defaults
win_inet_pton             1.0.1                    py37_1    defaults
win_unicode_console       0.5                      py37_0    defaults
wincertstore              0.2                      py37_0    defaults
winpty                    0.4.3                         4    defaults
wrapt                     1.10.11          py37hfa6e2cd_2    defaults
xlrd                      1.1.0                    py37_1    defaults
xlsxwriter                1.1.1                    py37_0    defaults
xlwings                   0.12.1                   py37_0    defaults
xlwt                      1.3.0                    py37_0    defaults
yaml                      0.1.7                hc54c509_2    defaults
yapf                      0.24.0                   py37_0    defaults
zeromq                    4.2.5                he025d50_1    defaults
zict                      0.1.3                    py37_0    defaults
zlib                      1.2.11               h8395fce_2    defaults
zope                      1.0                      py37_1    defaults
zope.interface            4.5.0            py37hfa6e2cd_0    defaults
@mingwandroid
Copy link

You must activate your conda environment in any other cmd.exe shell. Powershell support is planned but not yet ready.

https://conda.io/docs/user-guide/tasks/manage-environments.html

Closed as not a bug.

@timeregained
Copy link
Author

@mingwandroid ,

I have pointed in my previous comment :"I also tired to remove numpy from anaconda and install numpy with pip instead, it shows the pip version numpy(numpy-1.15.2-cp37-none-win_amd64.whl) does not have this issue."

It seems this issue related to the numpy package from anaconda rather than procedure of activating conda environment in shell.

@mingwandroid
Copy link

Out software requires activation. In this instance it sets PATH so the DLLs get found.

So you need to activate.

@timeregained
Copy link
Author

@mingwandroid

Thanks a lot for your reply.

And If it is a requirement for using anaconda python, would you please kindly help to advise how to make xlwings working as previous?

In previous anaconda release, this package only need to know the path of python and all works well.

e.g. anaconda python 3.6 (python 3.6.6 hea74fb7_0;numpy 1.15.2 py36ha559c80_0) does work well without any activation. However, I have tried Anaconda python 3.7 with numpy both 1.14 and 1.15, neither of them could work without activation.

So is this activation only get to be necessary when using Anaconda with python 3.7? I have checked the package structure of numpy-1.15.2-py36ha559c80_0 , it seems all the same as numpy-1.15.2 py37ha559c80_0, if some dlls needed to be found with the activation of shell instance, I think both of them should fail rather than only failed in 3.7 build.

@mingwandroid
Copy link

I removed a hack deep in the guts of our python recently whereby it modified the PATH environment variable if it detected activation may not have happened correctly.

This breaks countless things in 3rd party software. I had no choice.

The simplest example of this breakage is trying to use Python to query PATH. It will give the incorrect answer.

But regardless, activation can involve more than setting PATH, packages can do arbitrary things in activation scripts. In summary, if you choose to not activate then you can expect things to fail and we're not going to spend time debugging that for you.

@mingwandroid
Copy link

And packages that previously didn't require activation scripts can later introduce something that does require them so just because something (skipping activation) worked with an old package it doesn't mean it will continue to.

This isn't what's going on here though!

@timeregained
Copy link
Author

Thanks again for your patient, I will report this issue to xlwings maintenance guys, wish they would follow up the change.

@mingwandroid
Copy link

This is an end user issue nothing to do with any package. You are meant to activate your envs somehow (Anaconda Prompt, Anaconda navigator or by manually calling activate).

@y2kbugger
Copy link

Entry point for xlwings is from within Excel (for udfs) so it's not really an end user thing.

@msarahan
Copy link
Contributor

You can try setting the env var to use the alternate DLL loading scheme. More info at https://conda.io/projects/conda/en/latest/user-guide/troubleshooting.html#numpy-mkl-library-load-failed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants