导入时发生python错误(使用xlwings )

Question

下面是导入时的错误消息：

>>> from xlwings import workbook, range
Traceback (most recent call last):
  File "<pyshell#7>", line 1, in <module>
    from xlwings import workbook, range
  File "C:\Users\user\AppData\Local\Programs\Python\Python35\lib\site-packages\xlwings\__init__.py", line 20, in <module>
    from . import _xlwindows as xlplatform
  File "C:\Users\user\AppData\Local\Programs\Python\Python35\lib\site-packages\xlwings\_xlwindows.py", line 10, in <module>
    import win32api
ImportError: No module named 'win32api'

我尝试过Python3.5和2.7.10，但两者都没有成功。

Answer 1

确保安装了win32api包。用

pip install win32api

Answer 2

您需要安装pywin32。

pip install pywin32

Answer 3

请说明您的using.Windows或Mac环境？它有依赖性：

Windows

pywin32，组合

Mac

psutil、appscript

更多，请参考xlwing自述文档：

https://github.com/ZoomerAnalytics/xlwings