Item(Int32,Int32,Int32,Int32) Property

Visual Basic
C#

'Declaration
 
Public Overloads ReadOnly Property Item( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal row2 As Integer, _
   ByVal column2 As Integer _
) As Cell

'Usage
 
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)

public Cell Item( 
   int row,
   int column,
   int row2,
   int column2
) {get;}

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#

[ No support for the Item property exists in C#. ]

Visual Basic

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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Cells Class
Cells Members
Overload List