Skip to main content

IXlSheet.CurrentRowIndex Property

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

Namespace: DevExpress.Export.Xl

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

NuGet Packages: DevExpress.Printing.Core, DevExpress.Win.Dashboard.Design


int CurrentRowIndex { get; }

Property Value

Type Description

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


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.


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.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CurrentRowIndex property.


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.

See Also