Item Property (WorksheetRowCollection)

Gets the row at the specified index.

Syntax

C#

public WorksheetRow this[ 
   int index
]; {get;}

Parameters

index

The zero-based index of the row to get.

Property Value

The row at the specified index.

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	index is less than zero.
System.InvalidOperationException	index is greater than or equal to Workbook.MaxExcelRowCount or Workbook.MaxExcel2007RowCount, depending on the CurrentFormat.

Remarks

Note: Iterating the collection will not create all rows. It will only iterate the rows which have already been used. To create and iterate all rows in the worksheet use a For loop, iterating from 0 to one less than the maximum row count, and pass in each index to the collection's indexer.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+