Item Property (XLSheet)

Gets the cell at a specified position on the sheet, creating a new cell if necessary.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Default Property Item( _
   ByVal rowIndex As System.Integer, _
   ByVal colIndex As System.Integer _
) As XLCell

public XLCell this[ 
   System.int rowIndex,
   System.int colIndex
]; {get;}

Parameters

rowIndex
colIndex

Remarks

If the specified cell doesn't exist when the indexer is invoked, the sheet will be expanded and a new cell will be created, then returned. This makes it easy to create and populate sheets.

If you want to determine whether a specific cell has been defined, use the GetCell method instead.

The indexer is generally more useful when creating and populating sheets. The GetCell method is more useful when loading existing sheets.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

XLSheet Class
XLSheet Members