Cells

A collection of table cells.

Methods

Cell anyItem ()
Returns any Cell in the collection.

number count ()
Displays the number of elements in the Cell.

Array of Cell everyItem ()
Returns every Cell in the collection.

Cell firstItem ()
Returns the first Cell in the collection.

Cell item (index: any)
Returns the Cell with the specified index or name.

Parameter Type Description
index Long Integer
String		 The index or name. Can accept: Long Integer or String.

Cell itemByID (id: number)
Returns the Cell with the specified ID.

Parameter Type Description
id number The ID.

Cell itemByName (name: string)
Returns the Cell with the specified name.

Parameter Type Description
name string The name.

Array of Cell itemByRange (from: any, to: any)
Returns the Cells within the specified range.

Parameter Type Description
from Cell
Long Integer
String		 The Cell, index, or name at the beginning of the range. Can accept: Cell, Long Integer or String.
to Cell
Long Integer
String		 The Cell, index, or name at the end of the range. Can accept: Cell, Long Integer or String.

Cell lastItem ()
Returns the last Cell in the collection.

Cell middleItem ()
Returns the middle Cell in the collection.

Cell nextItem (obj: Cell)
Returns the Cell whose index follows the specified Cell in the collection.

Parameter Type Description
obj Cell The Cell whose index comes before the desired Cell.

Cell previousItem (obj: Cell)
Returns the Cell with the index previous to the specified index.

Parameter Type Description
obj Cell The index of the Cell that follows the desired Cell.

string toSource ()
Generates a string which, if executed, will return the Cell.

Element of:

Cell.cells
Column.cells
Row.cells
Table.cells
XMLElement.cells