AddCustomFunctionLibrary

Registers a new custom functions library (see the -SetCustomFunctions plugin method).
The description of the function parameters and result is specified using JSDoc. The @customfunction tag is required in JSDoc.
Parameters and results can be specified as the number / string / boolean / any / number[][] / string[][] / boolean[][] / any[][] types.
Parameters can be required or optional. A user can also set a default value.

Syntax

expression.AddCustomFunctionLibrary(sName, Func);

expression - A variable that represents a Api class.

Parameters

Name	Required/Optional	Data type	Default	Description
sName	Required	string		The library name.
Func	Required	function		The custom functions library code.

Returns

This method doesn't return any data.

Example

This example calculates custom function result.

• Code
• Result

// How to add custom function library.

// How to use custom function.

// How to add cell values using custom function library.

Api.AddCustomFunctionLibrary("LibraryName", function(){
	/**
	 * Function that returns the argument
	 * @customfunction
	 * @param {number} first First argument.
	 * @param {number} second Second argument.
	 * @returns {number} The sum of the numbers.
	 */
	Api.AddCustomFunction(function ADD(first, second) {
		return first + second;
	});
});

let worksheet = Api.GetActiveSheet();
worksheet.GetRange('A1').SetValue('=ADD(1,2)');