IXlSheet.CurrentRowIndex Property

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

Namespace: DevExpress.Export.Xl

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

Declaration

int CurrentRowIndex { get; }

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.

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.

See Also