PyXLL 2.0.4 (2013-07-23)¶
Patch release :
- 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.
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 functions.
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 as such.
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 1.3.1 (2012-01-14)¶
- 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.
PyXLL 1.1.0 (2010-07-06)¶
- support for python 2.7 added
- Minor GUI bug in the about dialog