Skip to main content

GetCount

Returns a value that represents a number of objects in the collection.

Syntax​

expression.GetCount();

expression - A variable that represents a ApiCharacters class.

Parameters​

This method doesn't have any parameters.

Returns​

number

Example​

Get a value that represents a number of objects in the collection in a spreadsheet.

// How to get collection objects count in a spreadsheet.

// How to get array length using the characters API in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("B1");
range.SetValue("This is just a sample text.");
let characters = range.GetCharacters(23, 4);
let count = characters.GetCount();
worksheet.GetRange("B3").SetValue("Number of characters: " + count);