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 a job done without 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. These technologies are far simpler and feature rich than the Excel C Development Kit and are actually well documented and supported....