Spread Windows Forms 7.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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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