IXlRow.RowIndex Property

Gets the zero-based index of the current row.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

int RowIndex { get; }

VB.NET

ReadOnly Property RowIndex As Integer

Property Value

Type	Description
Int32	An integer specifying the position of the row in the worksheet.

Remarks

Worksheet cells are organized into rows and columns. The number of rows and columns is permanently fixed and depends on the output file format (1,048,576 rows and 16,384 columns for XLSX files, and 65,536 rows and 256 columns for XLS files). Use the RowIndex property to obtain the zero-based index of the current row in a worksheet.

To obtain the index of the row that contains the specified cell, use the IXlCell.RowIndex property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RowIndex property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L327

using (IXlCell cell = row.CreateCell()) {
    cell.SetFormula(XlFunc.Sum(XlCellRange.FromLTRB(2, row.RowIndex, 5, row.RowIndex)));
    cell.ApplyFormatting(dataRowFormatting);

excel-export-library-generate-sales-analysis-report/CS/XLExportExample/Form1.cs#L248

XlCellFormatting formatting = new XlCellFormatting();
formatting.CopyFrom((row.RowIndex % 2 == 0) ? evenRowFormatting : oddRowFormatting);
// Set the bottom border for the last data row.

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/CS/XLExportExample/Form1.cs#L240

XlCellFormatting formatting = new XlCellFormatting();
formatting.CopyFrom((row.RowIndex % 2 == 0) ? evenRowFormatting : oddRowFormatting);
// Set the bottom border for the last data row.

excel-export-library-generate-an-invoice/CS/XLExportExample/Form1.cs#L526

// Set the formula to calculate the total amount.
cell.SetFormula(string.Format("SUM(H{0}:H{1})", firstDataRowIndex + 1, row.RowIndex - 1));
// Set the cell background color.

VB.NET

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L340

Using cell As IXlCell = row.CreateCell()
    cell.SetFormula(XlFunc.Sum(XlCellRange.FromLTRB(2, row.RowIndex, 5, row.RowIndex)))
    cell.ApplyFormatting(dataRowFormatting)

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L232

Dim formatting As XlCellFormatting = New XlCellFormatting()
formatting.CopyFrom(If(row.RowIndex Mod 2 = 0, evenRowFormatting, oddRowFormatting))
' Set the bottom border for the last data row.

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/VB/XLExportExample/Form1.vb#L224

Dim formatting As XlCellFormatting = New XlCellFormatting()
formatting.CopyFrom(If(row.RowIndex Mod 2 = 0, evenRowFormatting, oddRowFormatting))
' Set the bottom border for the last data row.

excel-export-library-generate-an-invoice/VB/XLExportExample/Form1.vb#L540

' Set the formula to calculate the total amount.
cell.SetFormula(String.Format("SUM(H{0}:H{1})", firstDataRowIndex + 1, row.RowIndex - 1))
' Set the cell background color.