Excel freezing/crashing problem affecting some uses of asnyc_call and auto-resizing array functions fixed.
This was a problem for some users when attempting to update Excel while calculations were still occurring.
Occasional crash when exiting Excel when using background Python threads fixed.
License keys surrounded by “< >” are ignored (regression from previous version).
PyXLL 3.2.1 (2017-03-22)
Minor update to Canopy license manager integration.
PyXLL 3.2.0 (2017-03-01)
License manager changes for better Canopy integration. This does not affect existing license keys.
The “deep reload” feature has been re-written to address problems occurring with the initial implementation.
It now works with relative imports correctly, and problems associated with reloading PyXLL multiple times
causing reloading errors have been addressed.
‘deep_reload_include’ and ‘deep_reload_exclude’ can be set together to restrict the set of modules that
will be reloaded when using deep reloading.
When using auto resized arrays the Python function could get called multiple times. Now the Python function
will only be called once.
Non-ASCII characters from the pyxll stubs package have been removed.
A bug in the stubs version of xl_app when using xlwings has been resolved.
PyXLL 3.1.1 (2016-12-05)
Fix problem when recalculating from a ribbon function.
The deep reload feature no longer tries to reload standard modules or those with c extensions.
Fix bug preventing some functions from loading in Excel 2003
PyXLL 2.0.3 (2013-02-23)
Patch release :
Better error reporting when Python can’t be initialized
Fix compatibility problem with PyGTK
Fix sub-menu bug in Python 3 build
Fix bug that causes a crash when multiple PyXLL addins are loaded using the same Python runtime
PyXLL 2.0.2 (2012-10-25)
Patch release :
Fixed problem setting log path in external config
Fixed crash bug when using thread-safe excel functions with some Python interpreters
PyXLL 2.0.1 (2012-10-11)
Patch release :
Fixed problem with PyXLL crashing on initialisation in some situations.
PyXLL 2.0.0 (2012-09-30)
New features :
Python 3 compatibility (3.2 and 3.3 build are available)
64 bit build available.
The 64 bit version is for use with the 64 bit version of Excel 2010, and
requires a 64 bit version of Python to be installed.
Parameter descriptions in python function docstrings are automatically used
as help strings in Excel, or may be explicitly declared and passed to the
xl_func decorator. See Documenting Functions.
API changes :
xlfCaller now returns an XLCell instance instead of the address
of the calling cell. xlfCaller no longer requires the calling function
to be registered as a macro sheet equivalent function so may be used in thread-safe
XLCell has additional properties sheet_id and rect which may be accessed
without the calling function being a macro sheet equivalent function. Access to
all other properties requires the calling function to be a macro sheet equivalent
function (as before).
xl_cell argument type no longer implicitly makes the function a macro sheet equivalent
function. If access to the XLCell properties requiring the function to be
a macro sheet equivalent function is required the function must be explicitly registered
var argument type is now a unicode string for Excel string parameters in Excel 2007
and Excel 2010. This matches the contents of the actual parameter as it is in Excel.
New function xlAbort wrapping the Excel function of the same name.
This function may be used to test for a user requested abort in a long running
macro or menu function.
Other changes :
Non-commercial use pop-up window is only displayed once and can be dismissed immediately
without the previous 15 second delay.
Relative paths work correctly when used in external configs and are relative to
the config file, not the PyXLL addin as before.
Improved PyDev debugging.
Re-attaching now works after detaching from Eclipse.
PyXLL 1.3.3 (2012-03-17)
Patch release to stop macro sheet equivalent functions with var arguments being treated as volatile by default by Excel.
PyXLL 1.3.2 (2012-02-05)
Patch release to fix compatibility issues in Python 2.6 version.
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).
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
XLCell type now works for cells past IV:65356 in Excel 2007 and 2010.
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.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.0 (2011-05-03)
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 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.1.1 (2010-10-04)
Patch release to fix a bug that some users were experiencing when using PyXLL with Excel 2010.