Patch release to stop macro sheet equivalent functions with var arguments being treated as volatile by default by Excel.
New features:
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.
There have been several internal changes to make sure PyXLL is compatible with any distribution of Python (now including PortablePython).
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.
Patch release the fixes a problem passing arrays of floats using the float[] type affecting some versions of Excel 2007.
Patch release to fix an issue where Python bools returns as ‘var’ would be returned to Excel as integers.
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
