Patch release:
Fix a problem with get_active_object for Excel 2013 and 2016 where it would stop working after
closing the first opened workbook.
Patch release:
Fix get_dialog_type for Excel 2013 and 2016 that was causing the disable_function_wizard_calc
and disable_replace_calc kwargs to xl_func not to work.
Patch release:
Fix for importing from site-packages affecting some Anaconda distributions.
Fix problem affecting Windows XP users without SP2 installed.
New Features :
Python 3.5 support added.
is_calculated property added to XLCell.
quiet option added to configuration.
name kwarg added to xl_func and xl_macro to allow functions to be
registered with a name other that the Python function name.
New function xlfVolatile.
In Python 3 the string type now accepts unicode strings (there’s now no difference between string and unicode in Python 3).
external_config may be a pattern and all matching files will be used.
Menu ordering may be set in the config file (see configuration).
Fixes :
Rare case where get_active_object would fail has been fixed.
Problem with certain functions with float[] return type in Excel 2010 and 2013 has been fixed.
Fixed a bug in the callbacks example where it was using win32api without importing it. It now uses xlcAlert instead.
Fixed issue with the sort order of sub-menus.
Patch release :
Fix compatibility issue with Windows XP.
Fix import error in pyxll.py stubs module.
New Features :
Python 3.4 support.
Users can interrupt functions by pressing Esc (see new allow_abort kwarg to xl_func,
xl_macro and xl_menu).
Log startup information to file pointed to by environment variable PYXLL_DEBUG_LOG to make finding setup problems easier.
Fixes :
Added get_type_converter to pyxll.py stubs module.
Fix issue with precision of converting datetimes from Excel.
Fix issue with sub-menus not always being deleted when reloading/rebinding.
Excel functions (eg xlcAlert) accept unicode strings from Excel 2007 onwards.
Fixed problems with Canopy when not installed as the default Python.
Other Changes :
Missing external configs are logged as warnings instead of raising an exception.
More helpful error information when there are problems loading Python.
New Features :
Excel 2013 support (both 32 bit and 64 bit versions)
API Changes :
Type ‘float_nan’ converts all non-number types (e.g. empty cells) to NaN instead of only errors.
Added property XLCell.sheet_name.
Added functions xlSheetNm and xlSheetId.
Patch release :
Fix bug preventing some functions from loading in Excel 2003
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
Patch release :
Fixed problem setting log path in external config
Fixed crash bug when using thread-safe excel functions with some Python interpreters
Patch release :
Fixed problem with PyXLL crashing on initialisation in some situations.
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.
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 Argument and Return Types.
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.
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.
Re-attaching now works after detaching from Eclipse.
