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 number for the start of the range of cells
- column
- Column number for the start of the range of cells
- row2
- Row number for the end of the range of cells
- column2
- Column number for the end of the range of cells
Property Value
Cell objectException | 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 creates a Cell object, defines it as a DateTime cell and puts a Value of Now in the cell. It assigns itself to the Cells objects Item property.
C# | Copy Code |
---|---|
[ No support for the Item property exists in C#. ] |
Visual Basic | Copy Code |
---|---|
Dim mycell As FarPoint.Web.Spread.Cell mycell = FpSpread1.Cells(0, 0, 4, 4) mycell.CellType = New FarPoint.Web.Spread.DateTimeCellType() mycell.Value = Date.Now |
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6