Write add-ins, custom functions (UDFs), and macros with Python in Excel. Run locally or on your infrastructure with all the packages you need.
UPDATE: xlwings Lite , my answer to Python in Excel, is now available in the official Excel add-in store for free. On August 22, 2023, Microsoft revealed the preview of “Python in Excel”. As creator of xlwings and author of the O’Reilly book Python for Excel , I was obviously curious to give it a try. Since you shouldn’t judge a book by its cover, I decided to take a deep dive and record a…
It’s been possible to automate Google Sheets via the Google Sheets API for many years and there are multiple Python packages available that wrap this API: there’s gspread , pygsheets , ezsheets , and Google’s own google-api-python-client . All these packages talk from Python to Google Sheets and require you to create a Google Cloud Platform project, download a credentials file, and potentially…
In December 2020, Microsoft announced Lambda Functions as a new Excel feature. Lambda functions are an exciting way to define custom functions (a.k.a. user-defined functions) by only relying on Excel formulas, without having to use VBA or writing an add-in. In this blog post, we’re going to see how Lambda Functions work and why they are so awesome. It’s not all roses though: we’ll also look at the…
Python is a popular tool for all kind of automation needs and therefore a great candidate for your reporting tasks. There is a wealth of techniques and libraries available and we’re going to introduce five popular options here. After reading this blog post, you should be able to pick the right library for your next reporting project according to your needs and skill set.
The days of Ctrl-Shift-Enter and You can't change part of an array are finally over! Say hello to the new dynamic arrays that Microsoft has now (July 2019) rolled out to a broader user base: their Office 365 subscribers who are on the monthly channel.
If you have the free xlwings Excel add-in installed, you can query your data using standard SQL statements, like this:
Many (business) users use Excel to create full blown applications. However, unlike applications developed by professional software developers, Excel tools fall short of most software development practices that are considered minimal standards. This introduces risks that can lead to reputational damages and substantial financial losses (remember the «London Whale»).
Get market data from Quandl and other data providers directly via cell formulas: