View this email in your browser

In the News

Office 2021 and Python 3.10 were both released last week, just 1 day apart from each other (is it a sign?). Excel 2021 finally got dynamic arrays and the XLOOKUP formula, while Python got the match/case statement and more precise Tracebacks. Note that Excel 2021 is the version of Excel that comes with a permanent license. Dynamic arrays and XLOOKUP have been available with Microsoft 365 (previously known as Office 365) for some time now.

• Read more about Office 2021 on Tech Advisor

• Read more about Python 3.10 on Real Python

Weekly Tip #24

The following tip was published today. Make sure to follow xlwings either on

LinkedIn

or

so you won't miss any of the upcoming tips! It'll also allow you to join the discussion or ask questions around that topic.

Excel stores all numbers as floats, even if they appear to be integers. With xlwings, you can use the "numbers" option to convert all numbers into integers. Instead of "int", you could also use a custom function.