Zoomer News #12

Use xlwings with other office apps

October 08, 2018

In the News

: This is a really big announcement from this year's Ignite Conference: Microsoft is adding native support for dynamic arrays to Excel. So far, xlwings has provided this feature via a workaround (some would call it a "dirty hack") so we hope to support the native version soon with xlwings. You will read it here as soon as it's available. Note that this feature is not generally available yet and will be rolled out over the next months to Office 365 insiders.

xlwings v0.12: Call Python functions from VBA in all Microsoft Office apps

xlwings now works with all Microsoft Office apps: Whether you need

Outlook to perform a quick check in Python

before sending an email or if you have legacy VBA code that is split between Excel and Access: With xlwings v0.12, you can call Python functions from VBA within all Microsoft Office apps. See the

release notes

xlwings works now with Python 3.7

xlwings is now available for Python 3.7 on all channels (pip/pipenv, conda and conda-forge). If you use pip/pipenv, make sure to upgrade pywin32 to version 224 or you will run into issues.