Spread Windows Forms 6.0 Product Documentation
Get(Int32,Int32) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Rows Class > Get Method : Get(Int32,Int32) Method


row
Starting row index
row2
Ending row index

Glossary Item Box

Gets a specified range of rows.

Syntax

Visual Basic (Declaration) 
Public Overloads Function Get( _
   ByVal row As Integer, _
   ByVal row2 As Integer _
) As Row
Visual Basic (Usage)Copy Code
Dim instance As Rows
Dim row As Integer
Dim row2 As Integer
Dim value As Row
 
value = instance.Get(row, row2)
C# 
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.
C#Copy Code
FarPoint.Win.Spread.Row r;
r = fpSpread1.ActiveSheet.Rows.Get(2);
r.BackColor = Color.Yellow;
Visual BasicCopy Code
Dim r As FarPoint.Win.Spread.Row
r = FpSpread1.ActiveSheet.Rows.Get(2, 5)
r.BackColor = Color.Yellow

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.