Installation

The easiest way to install xlwings is via pip:

pip install xlwings

or conda:

conda install xlwings

Note that the official conda package might be few releases behind. You can, however, use the conda-forge channel (see: https://anaconda.org/conda-forge/xlwings) which should be reasonably up to date (but might still be a few days behind the pip release):

conda install -c conda-forge xlwings

Alternatively, it can be installed from source. From within the xlwings directory, execute:

python setup.py install

Note

When you are using Mac Excel 2016 and are installing xlwings with conda (or use the version that comes with Anaconda), you’ll need to run $ xlwings runpython install once to enable the RunPython calls from VBA. Alternatively, you can simply install xlwings with pip.

Dependencies

  • Windows: pywin32, comtypes

    On Windows, it is recommended to use one of the scientific Python distributions like Anaconda, WinPython or Canopy as they already include pywin32. Otherwise it needs to be installed from here which can be a hassle.

  • Mac: psutil, appscript

    On Mac, the dependencies are automatically being handled if xlwings is installed with conda or pip. However, with pip, the Xcode command line tools need to be available. Mac OS X 10.4 (Tiger) or later is required. The recommended Python distribution for Mac is Anaconda.

Optional Dependencies

  • NumPy
  • Pandas
  • Matplotlib
  • Pillow/PIL

These packages are not required but highly recommended as they play very nicely with xlwings.

Add-in

Please see Add-in on how to install the xlwings add-in.

Python version support

xlwings is tested on Python 2.7 and 3.3+