Spread Windows Forms 11.0 Product Documentation
Get(Int32,Int32) Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Rows Class > Get Method : Get(Int32,Int32) Method
Starting row index
Ending row index
Gets a specified range of rows.
Syntax
'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
ExceptionDescription
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;
Dim r As FarPoint.Win.Spread.Row
r = FpSpread1.ActiveSheet.Rows.Get(2, 5)
r.BackColor = Color.Yellow
See Also

Reference

Rows Class
Rows Members
Overload List