The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Worksheet.Rows Property

Provides access to the collection of all rows contained in the worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

RowCollection Rows { get; }
ReadOnly Property Rows As RowCollection
RowCollection Rows { get; }
ReadOnly Property Rows As RowCollection
RowCollection Rows { get; }
ReadOnly Property Rows As RowCollection

Property Value

Type Description
RowCollection

A RowCollection object specifying the worksheet's collection of rows.

Property Value

Type Description
RowCollection

A RowCollection object specifying the worksheet's collection of rows.

Property Value

Type Description
RowCollection

A RowCollection object specifying the worksheet's collection of rows.

Remarks

Use the Rows property to access an individual row in the worksheet or perform different operations over an individual or multiple rows (for example, group, insert or delete rows).

To work with worksheet columns, use the ColumnCollection object accessed via the Worksheet.Columns property.

Examples

This example demonstrates how to access rows in a worksheet. Use the Worksheet.Rows property to get a collection of rows contained in a worksheet (the RowCollection object). To get an individual row by its index (zero-based) or heading ("1", "2", "3", etc.), use the RowCollection.Item property.

using DevExpress.Spreadsheet;
// ...

Workbook workbook = new Workbook();

// Access a collection of rows.
RowCollection rows = workbook.Worksheets[0].Rows;

// Access the first row by its index in the collection of rows.
Row firstRow_byIndex = rows[0];

// Access the first row by its unique name.
Row firstRow_byName = rows["1"];
See Also