Skip to main content

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​

Use built-in functions using worksheet function objects in a spreadsheet.

// 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"));