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 Interface

A single row in a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

public interface Row :
    CellRange,
    Formatting,
    IEnumerable<Cell>,
    IEnumerable
Public Interface Row
    Inherits CellRange,
             Formatting,
             IEnumerable(Of Cell),
             IEnumerable
public interface Row :
    CellRange,
    Formatting,
    IEnumerable<Cell>,
    IEnumerable
Public Interface Row
    Inherits CellRange,
             Formatting,
             IEnumerable(Of Cell),
             IEnumerable
public interface Row :
    CellRange,
    Formatting,
    IEnumerable<Cell>,
    IEnumerable
Public Interface Row
    Inherits CellRange,
             Formatting,
             IEnumerable(Of Cell),
             IEnumerable

Remarks

Worksheet cells are organized into 1,048,576 rows and 16,384 columns that are stored in the RowCollection and ColumnCollection objects, respectively. To access these objects, use the Worksheet.Rows and Worksheet.Columns properties.

The Row object specifies an individual row in a worksheet and can be accessed by the row index or heading. Use this object's properties and methods to manage worksheet rows. For details, see the Rows and Columns section of examples.

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;
// ...

IWorkbook workbook = spreadsheetControl1.Document;

// 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