xllify

Getting started

The quickest way to get started is with xllify Assistant — build your functions directly in Excel without leaving the spreadsheet. When you're ready to work locally, export via Build > Export or start from the local-starter template.

References

• Standard library — ready-made Excel functions in Lua covering math, text, dates, finance, and more. Reference implementations you can use directly or adapt.
• Built-in globals — xllify.* native primitives and functional.* higher-order helpers available in every function you write.

How-to guides

• How to add your add-in to Excel
• Things you need to know about XLL add-ins
• Lua cheat sheet

Writing functions

Functions are written in Lua and registered with xllify.ExcelFunction:

xllify.ExcelFunction({
    name = "Add",
    description = "Adds two numbers",
    parameters = {
        { name = "a", type = "number", description = "First number" },
        { name = "b", type = "number", description = "Second number" }
    }
}, function(a, b)
    return a + b
end)

Parameter types: number, string, boolean. Set dimensionality = "matrix" to accept a range (how Excel ranges arrive in your function). Set execution_type = "async" for async functions that can use async.sleep() or async.http_get() (coming soon).