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