[Poetry]: Can't install xlwings; Could not find a version that satisfies the requirement pywin32==227

[paxcodes]

OS

macOS Mojave

Versions of xlwings, Excel and Python

Python 3.7.4

Describe your issue (incl. Traceback!)

When I install xlwings, it gives an error. (I use poetry if that makes any difference. But I think it shouldn't since it uses pip under the hood.)

$ poetry add xlwings
Using version ^0.18.0 for xlwings

Updating dependencies
Resolving dependencies... (3.7s)

Writing lock file


Package operations: 3 installs, 0 updates, 0 removals

  - Installing comtypes (1.1.7)
  - Installing pywin32 (227)

[EnvCommandError]
Command ['/Users/iflc/Library/Caches/pypoetry/virtualenvs/basecamp-CocmzNCA-py3.7/bin/pip', 'install', '--no-deps', 'pywin32==227'] errored with the following return code 1, and output: 
Collecting pywin32==227
  Could not find a version that satisfies the requirement pywin32==227 (from versions: )
No matching distribution found for pywin32==227

[fzumstein]

It's in fact a poetry issue, same as here: python-poetry/poetry#1287
The easiest fix for that would probably be to upload wheels instead of only the current source package.

[marcosfelt]

It seems that xlwings needs to switch to the environment markers specification. Something like this in setup.py:

install_requires = [
    "pywin32>=224; sys_platform==win; python_version>=3.7",
    "pywin32; sys_platform==win; python_version<3.7",
    "psutil>=2.0.0; sys_platform==darwin",
    "appscript>=1.0.1; sys_platform==darwin",
]

However, I'm not sure how to handle the data_files in this case, since they are in different locations between windows and MacOS.

It's unfortunate that xlwings currently doesn't work with poetry, so I'd like to fix that.

[fzumstein]

are you using poetry?

[marcosfelt]

Yes, and the error is still the same as the OP

[marcosfelt]

Perhaps the way around the issue with setup.py is to use pathlib.symlink_to in init.py, which completely removes the need for data_files.

[fzumstein]

for the time being, you should be able to install pywin32 directly, correct?

[marcosfelt]

The issue is on MacOS. Poetry somehow skips the sys.platform code and tries to install pywin32 on Mac.

[fzumstein]

gotcha

[jaymegordo]

+1 also having this issue!

[stonebig]

PyPy3 is not support per pywin32, would it be possible to switch to alternate ctypes thing ? like in jupyter/jupyter_core#230

[fzumstein]

PyPy3 is not support per pywin32, would it be possible to switch to alternate ctypes thing ? like in jupyter/jupyter_core#230

see #1603

[fzumstein]

also see https://setuptools.pypa.io/en/latest/userguide/dependency_management.html#platform-specific-dependencies