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.

How-to guides

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

Writing functions

Functions are written in Luau 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. Set execution_type = "async" for async functions that can use async.sleep() or async.http_get().

Standard library

A set of pre-written functions that xllify Assistant will use when they fit. See the standard library reference.