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
orpip
. 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.
Python version support¶
xlwings is tested on Python 2.7 and 3.3+