Item(Int32,Int32,Int32,Int32) Property

In This Topic

Gets (creates and returns) a Cell object for the range of cells specified.

Syntax

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

Exceptions

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

Example

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#
Visual Basic

Reference

Cells Class
Cells Members
Overload List