Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

RowCollection Interface

A collection of all rows in a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

public interface RowCollection

The following members return RowCollection objects:

#Remarks

Use the RowCollection object’s members to access, add, hide, group, and remove rows.

#Access Rows

Use the RowCollection.Item property to access an individual row in a worksheet.

#Obtain the Row at the Specified Index

using DevExpress.Spreadsheet;
// ...

// Access the row collection.
RowCollection rows = workbook.Worksheets[0].Rows;

// Access the first row in the collection.
Row firstRow = rows[0];

A row index is zero-based. It specifies the row position in the collection.

Row indexes

#Obtain the Row with a Given Heading

using DevExpress.Spreadsheet;
// ...

// Access the row collection.
RowCollection rows = workbook.Worksheets[0].Rows;

// Access the first row by its heading.
Row firstRow = rows["1"];

Row headings help users identify each row in a worksheet.

Row headings

#Insert Rows

Use the following methods to insert rows into a worksheet:

Row.Insert
Inserts a row above the current row.
RowCollection.Insert
Inserts rows at the specified position.

Note

The number of rows in a worksheet does not change - 1,048,576. When you add new rows, the rows below are shifted down and an equivalent number of rows at the end of the worksheet is removed.

#Insert a Single Row

// Insert the third row.
worksheet.Rows["3"].Insert();

// Insert the fifth row.
worksheet.Rows.Insert(4);

Insert a new row

#Insert Multiple Rows

// Insert three rows (from row 3 to row 5).
worksheet.Rows.Insert(2, 3);

Insert multiple rows

#Insert Rows Above a Specific Cell Range

Use the Worksheet.InsertCells method to insert empty rows above the specified cells. The method inserts the same number of rows as the specified cell range.

// Insert two rows above the "B3:E4" cell range.
worksheet.InsertCells(worksheet.Range["B3:E4"], InsertCellsMode.EntireRow);

Insert rows above specific cells

#Format Inserted Rows

Pass a RowFormatMode enumeration member to the RowCollection.Insert method to specify format options for inserted rows.

// Insert two rows with the same formatting as the first row.
worksheet.Rows.Insert(1, 2, RowFormatMode.FormatAsPrevious);

Insert rows and specify format options

#Remove Rows

Use the following methods to delete rows from a worksheet:

Row.Delete
Removes the current row.
RowCollection.Remove
Removes rows at the specified position.

Note

The number of rows in a worksheet does not change - 1,048,576. When you delete rows, the rows below are shifted up and an equivalent number of new rows is added to the end of the worksheet.

#Remove a Single Row

// Delete the second row.
worksheet.Rows[1].Delete();

// Delete the third row.
worksheet.Rows.Remove(2);

Remove a row

#Remove Multiple Rows

// Delete three rows (from row 2 to row 4).
worksheet.Rows.Remove(1, 3);

Remove multiple rows

#Remove Rows That Meet a Specific Condition

// Specify the condition to remove worksheet rows.
// If a value in the "D" column is greater than 30, remove the corresponding row. 
Func<int, bool> rowRemovalCondition = x => worksheet.Cells[x, 3].Value.NumericValue > 30.0;

// Delete rows that meet the specified condition.
// Check rows 2 through 7.
worksheet.Rows.Remove(1, 6, rowRemovalCondition);

Remove rows that meet a condition

#Remove Rows That Contain Specific Cells

Use the Worksheet.DeleteCells method to delete rows that contain the specified cell range.

// Delete a row that contains the "B2" cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);

Remove a row that contains a specific cell

#Group and Ungroup Rows

Use the RowCollection.Group method to group rows.

// Group rows 3 through 6 and collapse the group.
worksheet.Rows.Group(2, 5, true);

// Group rows 9 through 12 and expand the group.
worksheet.Rows.Group(8, 11, false);

// Group rows 2 through 13 to create the outer group. 
worksheet.Rows.Group(1, 12, false);

Group rows

Use the RowCollection.UnGroup method to ungroup rows.

// Ungroup rows 3 through 6 and display collapsed data.
worksheet.Rows.UnGroup(2, 5, true);

// Ungroup rows 9 through 12.
worksheet.Rows.UnGroup(8, 11, false);

// Remove the outer row group.
worksheet.Rows.UnGroup(1, 12, false);

#Expand or Collapse Groups

Use the following methods to collapse or expand row groups in a worksheet:

RowCollection.CollapseAllGroups
Collapses all row groups.
RowCollection.CollapseGroups
Collapses row groups starting with the specified group level.
RowCollection.ExpandAllGroups
Expands all row groups.
// Collapse all row groups except the first level group.
worksheet.Rows.CollapseGroups(2);

Collapse row groups

#Hide Rows

Use the Row.Visible property or the RowCollection.Hide method to hide rows in a worksheet.

// Hide rows 2 through 6.
worksheet.Rows.Hide(1, 5);

// Hide row 8.
worksheet.Rows[7].Visible = false;

Hide rows

Set the Row.Visible property to true to display a row. Use the RowCollection.Unhide method to show multiple hidden rows.

// Show rows 2 through 6.
worksheet.Rows.Unhide(1, 5);

// Show row 8.
worksheet.Rows[7].Visible = true;
See Also