| 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 object| 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 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family