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 columnsException | 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