Visual Basic (Declaration) | |
---|---|
Public Overloads ReadOnly Property Item( _ ByVal row As Integer, _ ByVal column As Integer _ ) As Cell |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As Cells Dim row As Integer Dim column As Integer Dim value As Cell value = instance.Item(row, column) |
Parameters
- row
- Row index of cell
- column
- Column index of cell
Property Value
Cell object for the specified row and columnException | 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 changes the background color of a cell.
C# | Copy Code |
---|---|
The Item property is not available in C#. Use the cell index. |
Visual Basic | Copy Code |
---|---|
FpSpread1.ActiveSheet.Cells.Item(0, 0).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