Fast and easy Excel custom functions with xllify and Lua

Excel is the original rapid application development tool. Developers can do unholy things to get the job done with no code, or perhaps with just a smattering of VBA. Long term, these solutions can end up brittle and hard to extend. Over the years there have been many approaches for extending Excel beyond formula soup and VBA. There is the excellent Excel-DNA, PyXLL, Microsoft’s own Office.js and Python support, among others....

August 27, 2025 · Alex Reid

Taming real-time data in Excel with rtd.pub

rtd.pub is a platform for easily connecting any real-time data source to Microsoft Excel. You can write code in Go and Python, or simply configure pre-built open source connectors. This is a design and approach I’ve been mulling over for the past couple of months. I have now implemented it. This, and of course spreadsheets in general, are somewhat boring. However, they’re the original low code/RAD tool: in terms of bang for buck and the control they put into the hands of domain experts, nothing comes close....

July 3, 2025 · Alex Reid