The easiest way to install xlwings is via pip:
pip install xlwings
conda install xlwings
Note that the official
conda package might be few releases behind. You can, however,
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
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
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.
On Mac, the dependencies are automatically being handled if xlwings is installed with
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.
These packages are not required but highly recommended as they play very nicely with xlwings.
Python version support¶
xlwings is tested on Python 2.7 and 3.3+