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 columnsException | 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