Class

Cells

 A collection of table cells.

See also Cell.

QuickLinks

[], anyItem, count, everyItem, firstItem, item, itemByID, itemByName, itemByRange, lastItem, middleItem, nextItem, previousItem, toSource

Properties

PropertyTypeAccessDescription
lengthnumber readonlyThe number of objects in the collection.

Methods

Instances

Cell [] (index: number)
Returns the Cell with the specified index.

ParameterTypeDescription
indexnumberThe index.

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: varies)
Returns the Cell with the specified index or name.

ParameterTypeDescription
indexLong Integer
String
The index or name. Can accept: Long Integer or String.

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

ParameterTypeDescription
idnumberThe ID.

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

ParameterTypeDescription
namestringThe name.

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

ParameterTypeDescription
fromCell
Long Integer
String
The Cell, index, or name at the beginning of the range. Can accept: Cell, Long Integer or String.
toCell
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.

ParameterTypeDescription
objCellThe Cell whose index comes before the desired Cell.

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

ParameterTypeDescription
objCellThe 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

Jongware, 28-Apr-2012 v3.0.3iContents :: Index