RowCollection Members
In This Article
#Properties
Name | Description |
---|---|
Item[Int32] | Provides indexed access to individual rows in the collection. |
Item[String] | Provides access to individual rows in the collection by their headings. |
Last |
Gets the index of the last edited row on a worksheet. |
#Methods
Name | Description |
---|---|
Auto |
Adjusts the height of rows to accommodate cell content. |
Auto |
Automatically creates an outline for the specified rows. |
Clear |
Removes an outline of rows. |
Clear |
Clears the outline for the specified rows. |
Collapse |
Collapses all the row groups in a worksheet. |
Collapse |
Collapses all row groups starting from the specified level. |
Expand |
Expands all the row groups in a worksheet. |
Group |
Groups the specified rows on a worksheet. |
Hide |
Hides the specified rows in a worksheet. |
Insert |
Inserts multiple rows and specifies how to format these rows. |
Insert |
Inserts multiple rows into the worksheet. |
Insert |
Inserts a new row into the worksheet at the specified position. |
Remove |
Removes rows that match the specified condition from the worksheet. |
Remove |
Removes rows that match the specified condition from the worksheet. |
Remove |
Removes rows that match the specified condition from the worksheet. |
Remove |
Removes multiple rows from the worksheet. |
Remove |
Removes the row at the specified position from the worksheet. |
Un |
Ungroups the grouped rows on a worksheet. |
Unhide |
Displays the hidden rows on a worksheet. |
See Also