Community
Select to view content in your preferred language

Xlsxwriter package won't install after updating pro to version 2.3

1512
1
02-15-2019 01:16 PM
ChelseaTabor1
by
Occasional Contributor
‎02-15-2019 01:16 PM

I updated ArcGIS Pro to version 2.3.0 this morning and updated my installed packages in the Python Package Manager.  However, after the update I'm missing the xlsxwriter package that I already had installed before the update.  I can find it when I search for packages, but the install won't work for me.  I've tried a few times now to reinstall the xlsxwriter package with no luck.  Does anyone know why it wouldn't be working?

0 Kudos
1 Reply
DanPatterson_Retired
by MVP Emeritus
MVP Emeritus
‎02-15-2019 05:51 PM

in your cloned environment?

If you are in control of your computer, you will have to install it in your cloned environment.

If you are in control, then you can do usually do an install using conda (your proenv.bat file)

But a dry run shows it isn't in the default channels

(arcgispro-py3) C:\...Your_Install_folder\bin\Python\envs\arcgispro-py3>conda install xlswriter --dry-run
Fetching package metadata .............

PackageNotFoundError: Packages missing in current channels:

  - xlswriter

We have searched for the packages in the following channels:

  - 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/msys2/win-64
  - https://repo.anaconda.com/pkgs/msys2/noarch
  - https://conda.anaconda.org/esri/win-64
  - https://conda.anaconda.org/esri/noarch‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I wouldn't suggest installing it as instructed from the anaconda pages, since it wants to update everything

(arcgispro-py3) C:\arc_pro\bin\Python\envs\arcgispro-py3>conda install -c anaconda xlsxwriter --dry-run
Fetching package metadata ...............
Solving package specifications: .

Package plan for installation in environment C:\arc_pro\bin\Python\envs\arcgispro-py3:

The following NEW packages will be INSTALLED:

    xlsxwriter:          1.1.2-py36_0           anaconda

The following packages will be UPDATED:

    openssl:             1.1.1a-he774522_0               --> 1.1.1-he774522_0       anaconda
    vs2015_runtime:      14.15.26706-h3a45250_0          --> 15.5.2-3               anaconda

The following packages will be SUPERSEDED by a higher-priority channel:

    asn1crypto:          0.24.0-py36_0                   --> 0.24.0-py36_0          anaconda
    atomicwrites:        1.3.0-py_0                      --> 1.3.0-py_0             anaconda

..... Huge Snip .....‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

pip install if you really need 

or they do have 

xlrd                      1.2.0                    py36_0
xlwt                      1.3.0            py36h1a4751e_0

which I find good and I have used it with my excel-array-table scripts

This can be used to convert excel files to numpy structured or record arrays. · GitHub 

from this link

/blogs/dan_patterson/2018/12/13/excel-arrays-tables-in-arcgis-pro 

Good luck

0 Kudos