Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Tony

Pages: [1] 2 3
1
News / Version 3.1.1 Released
« on: December 06, 2016, 12:23:30 PM »
Patch release

  • Fix problem when recalculating from a ribbon function.
  • The deep reload feature no longer tries to reload standard modules or those with c extensions.
  • Fix xl_app to work with xlwings 0.10.0.


2
News / Version 3.1 Released
« on: November 16, 2016, 11:55:52 AM »
New features

  • Python 3.6 support added.
  • Auto-resize option for functions returning arrays. See auto_resize argument to xl_func.
  • Keyboard shortcuts added to xl_macro and xl_menu.
  • Integration with ExcelDNA IntelliSense (https://github.com/Excel-DNA/IntelliSense).
  • Added xlwings option to xl_app.

Fixes

  • Fixed a problem with loading the ribbon that affected some users.
  • Missing reload and rebind functions added to stubs pyxll module.

3
News / Version 3.0 Released
« on: April 11, 2016, 09:09:25 AM »
New features

- Ribbon can be customized from PyXLL.
- RTD (real time data) functions.
- Function signatures are now optional.
- Default keyword arguments are supported.
- Python exe, dll and pythonhome can be set in the config.
- Deep reloading (reload modules and their dependencies).
- Errors are cached and can be retrieved by get_last_error.
- Python functions reload and rebind added.
- comtypes support.
- New xl_app function added.

Fixes

- Circular dependencies in the config file are now caught.
- Warning about custom types being redefined when reloading is fixed.
- Macro-equivalent functions with xl_cell argument types are no longer implicitly volatile.

4
News / Version 2.3 released
« on: September 24, 2015, 09:56:20 AM »
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.

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.

5
News / Version 2.2 released
« on: July 24, 2014, 06:29:48 PM »
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.

8
General Discussion / MOVED: Returning Arrays
« on: March 19, 2014, 02:21:28 PM »

10
News / Patch release 2.0.3 available
« on: February 23, 2013, 05:22:30 PM »
Hi,

version 2.0.3 is available to download, and fixes a few problems with the previous 2.0.2 release. Please see the changelog (http://www.pyxll.com/changelog.html) for details.

- 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

If you experience any problems with this release or have any questions or other feedback please let me know either on the forum or by emailing info@pyxll.com.

Best regards,
Tony

11
General Discussion / IPython console in Excel
« on: February 23, 2013, 12:23:42 PM »
I've attached some code that shows how to launch an IPython Qt console window from Excel, attached to an IPython kernal running in Excel.

This lets you interact directly with Excel using Python, try out code, and even write new Excel functions with the pyxll.xl_func decorator interactively.

This code requires IPython 0.13, PySide and psutil.

If you add new functions, menus or macros you need to tell PyXLL to re-create the Excel wrappers and register the functions with Excel. You can do with by calling the 'pyxll_rebind' macro, which can be done with the following Python code:

xl = xl_app() # from automation example
xl.Run("pyxll_rebind")

Let me know if you try this as I'm considering adding it as an example in a future PyXLL release.

Tony

12
News / Patch release 2.0.2 available
« on: October 25, 2012, 09:00:12 PM »
Hi,

version 2.0.2 is available to download, and fixes a few problems with the initial 2.0 release. Please see the changelog (http://www.pyxll.com/changelog.html) for details.

- Fixed problem setting log path in external config
- Fixed crash bug when using thread-safe excel functions with some Python interpreters
- Fixes problem with PyXLL crashing on initialization in some situations (from 2.0.1)

If you experience any problems with this release or have any questions or other feedback please let me know either on the forum or by emailing info@pyxll.com.

Best regards,
Tony

13
News / Version 2.0 released
« on: September 30, 2012, 04:26:46 PM »
 Hi,

version 2.0 of PyXLL is now available to download from www.pyxll.com/download.html.

For the full list of new features and changes please see www.pyxll.com/changelog.html.

This is the first version of PyXLL that supports Python 3 and 64 bit Excel.

To make PyXLL more attractive to use for personal and non-commercial use without a license key, the pop-up window that appears when PyXLL starts without a license key has been changed so you no longer have to wait 15 seconds to dismiss it. It also no longer re-appears when reloading PyXLL.

If you have any feedback or experience any problems please let me know.

Best regards,
Tony

14
News / Patch release 1.3.3 available
« on: March 17, 2012, 04:45:26 PM »
Hi,

patch release 1.3.3 is now available to download. This release is to stop macro sheet equivalent functions with var arguments being treated as volatile by default by Excel.

Best regards,
Tony

15
News / Patch release 1.3.2 available
« on: February 05, 2012, 02:41:09 PM »
Hi,

this patch release fixes compatibility issues with the Python 2.6 version of PyXLL.

If you were having problems loading PyXLL with your installed version of Python 2.6 previously please try again with this release and you should find those problems have been fixed.

As always, if you have any problems with PyXLL at all please report them either by email or via the forum.

Best regards,
Tony

Pages: [1] 2 3