Skip to main content

GetCount

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

Syntax​

expression.GetCount();

expression - A variable that represents a ApiAreas class.

Parameters​

This method doesn't have any parameters.

Returns​

number

Example​

This example shows how to get a value that represents the number of objects in the collection.

let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("B1:D1");
range.SetValue("1");
range.Select();
let areas = range.GetAreas();
let count = areas.GetCount();
range = worksheet.GetRange('A5');
range.SetValue("The number of ranges in the areas: ");
range.AutoFit(false, true);
worksheet.GetRange('B5').SetValue(count);