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 usually be up to date (but might still be a day or so behind the pip release):
conda install -c conda-forge xlwings
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, the dependencies are automatically being handled if xlwings is installed with
conda
orpip
.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. Withconda
on the other hand, you’ll need to manually run the commandxlwings runpython install
.
Optional Dependencies¶
- NumPy
- Pandas
- Matplotlib
- Pillow/PIL
- Flask (for REST API only)
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+