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


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

See Also

Reference

Rows Class
Rows Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.