Back to Devexpress

RowCollection Methods

officefileapi-devexpress-dot-spreadsheet-dot-rowcollection-dot-underscore-methods.md

latest3.9 KB
Original Source

RowCollection Methods

A collection of all rows in a worksheet.

NameDescription
AutoFit(Int32, Int32)Adjusts the height of rows to accommodate cell content.
AutoOutline()Automatically creates an outline for the specified rows.
ClearOutline()Removes an outline of rows.
ClearOutline(Int32, Int32)Clears the outline for the specified rows.
CollapseAllGroups()Collapses all the row groups in a worksheet.
CollapseGroups(Int32)Collapses all row groups starting from the specified level.
ExpandAllGroups()Expands all the row groups in a worksheet.
Group(Int32, Int32, Boolean)Groups the specified rows on a worksheet.
Hide(Int32, Int32)Hides the specified rows in a worksheet.
Insert(Int32, Int32, RowFormatMode)Inserts multiple rows and specifies how to format these rows.
Insert(Int32, Int32)Inserts multiple rows into the worksheet.
Insert(Int32)Inserts a new row into the worksheet at the specified position.
Remove(Func<Int32, Boolean>)Removes rows that match the specified condition from the worksheet.
Remove(Int32, Func<Int32, Boolean>)Removes rows that match the specified condition from the worksheet.
Remove(Int32, Int32, Func<Int32, Boolean>)Removes rows that match the specified condition from the worksheet.
Remove(Int32, Int32)Removes multiple rows from the worksheet.
Remove(Int32)Removes the row at the specified position from the worksheet.
UnGroup(Int32, Int32, Boolean)Ungroups the grouped rows on a worksheet.
Unhide(Int32, Int32)Displays the hidden rows on a worksheet.

See Also

RowCollection Interface

RowCollection Members

DevExpress.Spreadsheet Namespace