{"id":185,"date":"2016-03-15T17:09:48","date_gmt":"2016-03-15T17:09:48","guid":{"rendered":"https:\/\/www.pyxll.com\/blog\/?p=185"},"modified":"2019-12-14T19:08:03","modified_gmt":"2019-12-14T19:08:03","slug":"getting-started-with-pyxll","status":"publish","type":"post","link":"https:\/\/www.pyxll.com\/blog\/getting-started-with-pyxll\/","title":{"rendered":"Getting started with PyXLL"},"content":{"rendered":"

If you’re using Enthought Canopy you can download PyXLL from the Canopy Package Manager. For all other Python users simply download PyXLL from the\u00a0Download Page<\/a>\u00a0instead, where it says “Download PyXLL for Standalone Installation”.<\/p>\n

Once you’ve downloaded PyXLL, the rest of this post will get you up and running.<\/p>\n

When you download PyXLL, pay attention to what version of Python you are downloading for and whether you want the 32 bit or 64 bit version. If you are using a 32 bit version of Excel you must download the 32 bit PyXLL package and you will also need to use a 32 bit version of Python (PyXLL embeds Python into Excel, and so the processor version must be the same).<\/p>\n

Once you’ve done that, follow the following steps to install PyXLL:<\/p>\n

1. Unpack the zipfile<\/strong><\/h3>\n

Canopy users can skip this step<\/em><\/p>\n

PyXLL can be used with any Python distribution. Depending on how you have Python installed on your system\u00a0you may need to configure PyXLL so it knows where to find your Python installation.<\/p>\n

PyXLL is packaged as a zip file. Simply unpack the zip file where you want PyXLL to be installed, there\u00a0is no installer to run.<\/p>\n

2. Edit the config file<\/strong><\/h3>\n

Once you’ve unzipped the PyXLL download is to edit the file pyxll.cfg\u00a0<\/em>in any text editor. The default configuration may be fine for you while you’re getting started, and you can\u00a0come back to it later if you want to make any changes.<\/p>\n

Canopy users launch Canopy and type “edit_pyxll_configuration” to open the config file.<\/em><\/p>\n

If your Python installation is not configured to be the default Python installation (this is common with Anaconda and PortablePython distributions) you will need set the following in your config file<\/p>\n

[PYTHON]\r\nexecutable = <your python.exe file here><\/pre>\n
If you get an error saying that Python is not installed or the Python dll can’t be found you may need to set the Python executable in the config.<\/p>\n
If setting the executable doesn’t resolve the problem then it’s possible your\u00a0Python dll is in a non-standard location. You can also set the dll location\u00a0in the config to tell PyXLL where to find it.<\/p>\n
[PYTHON]\r\nexecutable = <your python.exe file here>\r\ndll = <your pythonXX.dll file here - usually not needed><\/pre>\n
3. Install the addin<\/strong><\/h3>\n
Once you’re happy with the configuration you can install the addin in Excel by following the instructions
\nbelow.<\/p>\n