GetItem

GetItem(ind) → { ApiRange }

Returns a single object from a collection by its ID.

Parameters:

Name Type Description
ind number

The index number of the object.

Returns:

Type
ApiRange

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("B1:D1");
oRange.SetValue("1");
oRange.Select();
var oAreas = oRange.GetAreas();
var oItem = oAreas.GetItem(1);
oRange = oWorksheet.GetRange('A5');
oRange.SetValue("The first item from the areas: ");
oRange.AutoFit(false, true);
oWorksheet.GetRange('B5').Paste(oItem);
builder.SaveFile("xlsx", "GetItem.xlsx");
builder.CloseFile();

Resulting document