xllify Assistant internal functions

The functions below are internal to the xllify Assistant add-in. They facilitate live previewing of your custom functions directly in Excel before you deploy them as a standalone add-in.

These functions are not part of the add-ins you build and deploy. They exist only within xllify Assistant to let you test and interact with your functions during development. We cannot make use of private APIs that tools like ScriptLab use to dynamically register functions, so have to use this dispatch method.

runFn

Dispatches to a xllify function by name with variadic arguments. Returns a scalar value.

Parameter Type Description
functionName string Name of the function to call — must be registered
args any (repeating, optional) Arguments to pass to the function

Returns: scalar (any type)

runFnMatrix

Dispatches to a xllify function by name with variadic arguments. Returns a matrix, allowing the result to spill across multiple cells.

Parameter Type Description
functionName string Name of the function to call — must be registered
args any (repeating, optional) Arguments to pass to the function

Returns: matrix (any type)