PyXLL Changelog

PyXLL 2.3

PyXLL 2.3.4 (2016-02-09)

Patch release:

  • Fix a compatibility problem with Python 3.4.4.

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

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

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

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

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)

New features:

  • Developer mode Excel commands pyxll_reload and pyxll_rebind.

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

New examples:

  • 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

Bug Fixes:

  • XLCell type now works for cells past IV:65356 in Excel 2007 and 2010.

PyXLL 1.2

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)

New features:

  • 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 examples:

  • 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

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)

New features:

  • support for python 2.7 added

Bug fixes:

  • Minor GUI bug in the about dialog

PyXLL 1.0

PyXLL 1.0.0 (2010-05-04)

First non-beta release.