RowCollection

RowCollection class

Collects the Row objects that represent the individual rows in a worksheet.

Methods

NameDescription
clear()Clear all rows and cells.
get()Gets a Row object by given row index. The Row object of given row index will be instantiated if it does not exist before
getCount()Gets the number of rows in this collection.
getRowByIndex(index)Gets the row object by the position in the list.
iterator()Gets an enumerator that iterates rows through this collection
removeAt(index)Remove the row item at the specified index(position) in this collection.

clear()

Clear all rows and cells.

get()

Gets a Row object by given row index. The Row object of given row index will be instantiated if it does not exist before.

getCount()

Gets the number of rows in this collection.

getRowByIndex(index)

Gets the row object by the position in the list.

ParameterTypeDescription
indexNumberThe position.

Returns: Row — Row The Row object at given position.

iterator()

Gets an enumerator that iterates rows through this collection

Returns: Iterator — Iterator enumerator

removeAt(index)

Remove the row item at the specified index(position) in this collection.

ParameterTypeDescription
indexNumberzero-based index(position, not