Get(Int32,Int32) Method

Gets a specified range of rows.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Get( _
   ByVal row As Integer, _
   ByVal row2 As Integer _
) As Row

'Usage
 
Dim instance As Rows
Dim row As Integer
Dim row2 As Integer
Dim value As Row
 
value = instance.Get(row, row2)

public Row Get( 
   int row,
   int row2
)

Parameters

row: Starting row index
row2: Ending row index

Return Value

Row object for the specified range of rows

Exceptions

Exception	Description
System.IndexOutOfRangeException	Specified row index is out of range. It must less than the row count or -1 for all.

Example

This example shows the use of the method in changing the background color of the row.

FarPoint.Win.Spread.Row r;
r = fpSpread1.ActiveSheet.Rows.Get(2);
r.BackColor = Color.Yellow;

Visual Basic

Dim r As FarPoint.Win.Spread.Row
r = FpSpread1.ActiveSheet.Rows.Get(2, 5)
r.BackColor = Color.Yellow

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

Rows Class
Rows Members
Overload List