IXlSheet.CurrentRowIndex Property

Gets the index of the row where the document exporter is currently positioned.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

int CurrentRowIndex { get; }

VB.NET

ReadOnly Property CurrentRowIndex As Integer

Property Value

Type	Description
Int32	A zero-based integer value that specifies the row index.

Remarks

The CurrentRowIndex property returns the zero-based index of the current row, if this row is still being generated. In other cases, the CurrentRowIndex returns the index of the row that follows the last generated row. If no rows have yet been generated, the CurrentRowIndex property returns 0.

Note

The number of rows in a worksheet is permanently fixed and depends on the output file format (1,048,576 rows for XLSX and CSV files, and 65,536 rows for XLS files). Note that you can use the IXlDocumentOptions.MaxRowCount property to obtain the maximum number of rows supported by the file format to which the document is exported.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CurrentRowIndex 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#L235

int firstDataRowIndex = sheet.CurrentRowIndex;

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

int firstDataRowIndex = sheet.CurrentRowIndex;

VB.NET

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

Dim firstDataRowIndex As Integer = sheet.CurrentRowIndex

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

Dim firstDataRowIndex As Integer = sheet.CurrentRowIndex

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

GenerateHeaderRow(sheet)
Dim firstDataRowIndex As Integer = sheet.CurrentRowIndex
' Create the data rows.

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

GenerateHeaderRow(sheet)
Dim firstDataRowIndex As Integer = sheet.CurrentRowIndex
' Create the data rows.