Patch release :
Patch release :
Patch release :
New features :
Python 3 compatibility (3.2 and 3.3 build are 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.
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.
Re-attaching now works after detaching from Eclipse.
Patch release to stop macro sheet equivalent functions with var arguments being treated as volatile by default by Excel.
Patch release to fix compatibility issues in Python 2.6 version.
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).
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.
- 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
Patch release to fix a bug that some users were experiencing when using PyXLL with Excel 2010.