Item(Int32,Int32) Property

Visual Basic
C#

'Declaration
 
Public Overloads ReadOnly Property Item( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer _
) As Cell

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim value As Cell
 
value = instance.Item(row, column)

public Cell Item( 
   System.int row,
   System.int column
) {get;}

Parameters

row: The row index.
column: The column index.

Property Value

A Cell object.

Exception	Description
System.IndexOutOfRangeException	Specified row index is not valid; must be between zero and the total number of rows.
System.IndexOutOfRangeException	Specified column index is not valid; must be between zero and the total number of columns.
System.IndexOutOfRangeException	Specified column header row index is not valid; must be between zero and the total number of column header rows.
System.IndexOutOfRangeException	Specified row header column index is not valid; must be between zero and the total number of row header columns.
System.IndexOutOfRangeException	Specified sheet corner row index is not valid; must be between zero and the total number of sheet corner rows.
System.IndexOutOfRangeException	Specified sheet corner column index is not valid; must be between zero and the total number of sheet corner columns.

This example uses the Item property.

C#

gcSpreadSheet1.Sheets[0].Item(1, 1).Tag = "test";
gcSpreadSheet1.Sheets[0].Item("test").Text = "Item Tag";
gcSpreadSheet1.Sheets[0].Item(2, 2, 3, 3).Text = "Block";

VB.NET

GcSpreadSheet1.Sheets(0).Item(1, 1).Tag = "test"
GcSpreadSheet1.Sheets(0).Item("test").Text = "Item Tag"
GcSpreadSheet1.Sheets(0).Item(2, 2, 3, 3).Text = "Block"

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List