| Visual Basic (Declaration) | |
|---|---|
Public Overloads ReadOnly Property Item( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal row2 As Integer, _ ByVal column2 As Integer _ ) As Cell  | |
| Visual Basic (Usage) |  Copy Code | 
|---|---|
Dim instance As Cells Dim row As Integer Dim column As Integer Dim row2 As Integer Dim column2 As Integer Dim value As Cell value = instance.Item(row, column, row2, column2)  | |
Parameters
- row
 - Row index of first cell in range
 - column
 - Column index of first cell in range
 - row2
 - Row index of last cell in range
 - column2
 - Column index of last cell in range
 
Property Value
Cell object for the range of cells of the specified rows and columns| Exception | Description | 
|---|---|
| System.IndexOutOfRangeException | Specified starting row index is not valid; must be between zero and the total number of rows | 
| System.IndexOutOfRangeException | Specified starting column index is not valid; must be between zero and the total number of columns | 
| System.IndexOutOfRangeException | Specified starting column header row index is not valid; must be between zero and the total number of column header rows | 
| System.IndexOutOfRangeException | Specified starting row header column index is not valid; must be between zero and the total number of row header columns | 
| System.IndexOutOfRangeException | Specified starting sheet corner row index is not valid; must be between zero and the total number of sheet corner rows | 
| System.IndexOutOfRangeException | Specified starting sheet corner column index is not valid; must be between zero and the total number of sheet corner columns | 
| System.IndexOutOfRangeException | Specified ending row index is not valid; must be between zero and the total number of rows | 
| System.IndexOutOfRangeException | Specified ending column index is not valid; must be between zero and the total number of columns | 
| System.IndexOutOfRangeException | Specified ending column header row index is not valid; must be between zero and the total number of column header rows | 
| System.IndexOutOfRangeException | Specified ending row header column index is not valid; must be between zero and the total number of row header columns | 
| System.IndexOutOfRangeException | Specified ending sheet corner row index is not valid; must be between zero and the total number of sheet corner rows | 
| System.IndexOutOfRangeException | Specified ending sheet corner column index is not valid; must be between zero and the total number of sheet corner columns | 
This example changes the background color of several cells.
             
            
            | C# |  Copy Code | 
|---|---|
The Item property is not available in C#. Use the cell indexes.  | |
| Visual Basic |  Copy Code | 
|---|---|
FpSpread1.ActiveSheet.Cells.Item(0, 0, 2, 2).BackColor = Color.Yellow  | |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8