PyXLL 2 Changelog ¶

PyXLL 2.3.3 (2015-11-26) ¶

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.

PyXLL 2.3.2 (2015-11-19) ¶

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.

PyXLL 2.3.1 (2015-10-03) ¶

Patch release:

• Fix for importing from site-packages affecting some Anaconda distributions.
• Fix problem affecting Windows XP users without SP2 installed.

PyXLL 2.3.0 (2015-09-24) ¶

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.

PyXLL 2.2.2 (2014-11-11) ¶

Patch release:

• Changes to evaluation and about dialogs.

PyXLL 2.2.1 (2014-08-20) ¶

Patch release :

• Fix compatibility issue with Windows XP.
• Fix import error in pyxll.py stubs module.

PyXLL 2.2.0 (2014-07-10) ¶

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.

PyXLL 2.1.0 (2014-01-23) ¶

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.

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.

• 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.

• 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.