RowCollection
Contents
[
Hide
]RowCollection class
Collects the Row objects that represent the individual rows in a worksheet.
Properties
| Name | Type | Description |
|---|---|---|
| Count | int | Gets the number of rows in this collection. |
| Item (int) | Row | Gets a Row object by given row index. The Row object of given row index will be instantiated if it does not exist before |
Methods
| Name | Description |
|---|---|
| iterator | Gets an enumerator that iterates rows through this collection |
| getRowByIndex | Gets the row object by the position in the list. |
| clear | Clear all rows and cells. |
| removeAt | Remove the row item at the specified index(position) in this collection. |
RowCollection.Count property
Gets the number of rows in this collection.
Type: int
RowCollection.Item (int) property
Gets a Row object by given row index. The Row object of given row index will be instantiated if it does not exist before.
Type: Row
iterator()
Gets an enumerator that iterates rows through this collection
Returns: enumerator
getRowByIndex(index)
Gets the row object by the position in the list.
| Parameter | Type | Description |
|---|---|---|
| index | int | The position. |
Returns: The Row object at given position.
clear()
Clear all rows and cells.
removeAt(index)
Remove the row item at the specified index(position) in this collection.
| Parameter | Type | Description |
|---|---|---|
| index | int | zero-based index(position, not Row.Index ) of the existing row item in this collection. |