xlwings Newsletter #12

xlwings is dropping Python 2.7 support

December 02, 2019

Blog Posts

xlwings is dropping support for Python 2.7 - or is it?

In sync with Python 2's EOL on January 1st, 2020, xlwings will drop support for Python 2.7. This is also in line with the vast majority of open-source packages, see 

.

However, we do know that it's not always in your own hands to switch away from legacy Python, so here is what you can do after January 1st if you are stuck with Python 2.7:

  • You can keep using the latest version of xlwings that supports 2.7. Presumably, this will be xlwings 0.16.x. This means, however, that you won't get any new features or bug fixes.

  • Alternatively, you can switch to our new offering xlwings PRO. We will continue to support Python 2.7 for paying customers and you will get some nice add-ons like dedicated support from the core team, access to video training and additionally, your feature requests will be prioritized. Expect more stuff to be added in the future.

For more details about xlwings PRO, see: 

 or reply directly to this email and we will be happy to get back to you.

xlwings CE: recent updates

Our recent launch of

is driving the addition of quite a few new features in xlwings:

v0.16.0 added a "Run" button that automatically calls the "main" function of your Python script with the same name as your workbook:

This has the advantage that you can now run xlwings scripts on standard "xlsx" files, i.e. no need to save them as macro-enabled workbooks.

v0.16.1 added support for xw.Book parameters that allow you to deal with such things as external link updating, password protection or read-only mode. For details, see the

.

Event Calendar