Search code examples
pythonpywin32xlwings

python error when import (using xlwings lib)


Below is the error message when I import:

>>> 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'

I have tried Python 3.5 and 2.7.10 but both have no luck.


Solution

  • Make sure you have win32api package installed. Install it using

    pip install win32api