| Visual Basic (Declaration) | |
|---|---|
Public Overloads Function Get( _ 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.Get(row, column, row2, column2)  | |
Parameters
- row
 - Starting row index of range of cells
 - column
 - Starting column index of range of cells
 - row2
 - Ending row index of range of cells
 - column2
 - Ending column index of range of cells
 
Return Value
Cell object for the range of cells of the specified rows and columns| Exception | Description | 
|---|---|
| System.IndexOutOfRangeException | Specified row or column index is less than 0 or greater than or equal to the row count or column count. | 
| 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 row index is not valid; must be between zero and the total number of column header rows | 
| System.IndexOutOfRangeException | Specified starting column index is not valid; must be between zero and the total number of row header 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 row index is not valid; must be between zero and the total number of column header rows | 
| System.IndexOutOfRangeException | Specified ending column index is not valid; must be between zero and the total number of row header columns | 
| C# |  Copy Code | 
|---|---|
private void button1Click(object sender, System.EventArgs e) { FarPoint.Win.Spread.Cell cell; cell = fpSpread1.ActiveSheet.Cells.Get(0, 0, 3, 3); cell.BackColor = Color.Yellow; }  | |
| Visual Basic |  Copy Code | 
|---|---|
Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cell As FarPoint.Win.Spread.Cell cell = FpSpread1.ActiveSheet.Cells.Get(0, 0, 3, 3) cell.BackColor = Color.Yellow End Sub  | |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8