GetWorksheetFunction

Returns the ApiWorksheetFunction object.

Syntax

expression.GetWorksheetFunction();

expression - A variable that represents a Api class.

Parameters

This method doesn't have any parameters.

Returns

ApiWorksheetFunction

Example

This example shows how to use built-in functions using worksheet function objects.

• Code
• Result

// How to use system functions in a spreadsheets.

// Use built-in functions in a worksheet.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.ASC("text"));