Changelog

PyXLL 1.3

PyXLL 1.3.1 (2012-01-14)

New features:

• Developer mode Excel commands pyxll_reload and pyxll_rebind.

  PyXLL can now be made to reload all python modules or to update its Excel function bindings via these Excel macro commands. This works from outside Excel so it’s possible to do it from the command line or from an editor.

• Compatible with more versions of Python.

  There have been several internal changes to make sure PyXLL is compatible with any distribution of Python (now including PortablePython).

• Improved method for loading the Python dll.

  PyXLL will now look for a python dll in the same folder as itself before trying to load it from the system path. If it can’t find a suitable python dll it will now display an error dialog, whereas before Excel would simply report that it wasn’t possible to load the addin.

• Config file may now contain multi-line pythonpaths and module lists

• New function get_type_converter for getting functions that convert between types PyXLL knows about (including custom types).

New examples:

• Eclipse and PyDev debugger example that shows how to attach the PyDev interactive debugger to PyXLL.
• Reloading example to show how to tell PyXLL to reload all modules or import/reload a module and rebind the Excel functions

Bug Fixes:

• XLCell type now works for cells past IV:65356 in Excel 2007 and 2010.

PyXLL 1.3.2 (2012-02-05)

Patch release to fix compatibility issues in Python 2.6 version.

PyXLL 1.2

PyXLL 1.2.0 (2011-05-03)

New features:

• Asynchronous function support for Excel 2010
• Unicode support for Excel 2007 and 2010
• New xl_func kwarg to disable calculation in the function wizard
• Callbacks to execute user code when PyXLL opens, closes and reloads
• Config is readable by user code and supports variable substitution
• Added more Excel macro functions, including xlcAlert, xlcCalculation and xlcCalculateNow

New examples:

• New example showing how to cache Python objects and pass them between Excel functions
• A menu item example showing how to open the log file
• Various callback examples

PyXLL 1.2.1 (2011-8-31)

Patch release to fix an issue where Python bools returns as ‘var’ would be returned to Excel as integers.

PyXLL 1.2.2 (2011-09-05)

Patch release the fixes a problem passing arrays of floats using the float[] type affecting some versions of Excel 2007.

PyXLL 1.1

PyXLL 1.1.0 (2010-07-06)

New features:

• support for python 2.7 added

Bug fixes:

• Minor GUI bug in the about dialog

PyXLL 1.1.1 (2010-10-04)

Patch release to fix a bug that some users were experiencing when using PyXLL with Excel 2010.

PyXLL 1.0

PyXLL 1.0.0 (2010-05-04)

First non-beta release.