Rows Property (FpSpread)

Gets the rows in the client area of the active sheet in the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Rows As Rows

'Usage
 
Dim instance As FpSpread
Dim value As Rows
 
value = instance.Rows

public Rows Rows {get;}

Property Value

Rows object containing the rows in the data area of the currently selected sheet.

Remarks

This property is available at run time only.

Example

This example creates three row headers, displays letters in the first header and changes its background color to red. The first row displays a yellow border around its cells.

FpSpread1.RowHeader.ColumnCount = 3;
FpSpread1.RowHeader.AutoText = FarPoint.Web.Spread.HeaderAutoText.Letters;
FpSpread1.RowHeader.AutoTextIndex = 0;
FpSpread1.RowHeader.Columns[0].BackColor = Color.Red;
FpSpread1.Rows[0].Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Yellow, 2);

Visual Basic

FpSpread1.RowHeader.ColumnCount = 3
FpSpread1.RowHeader.AutoText = FarPoint.Web.Spread.HeaderAutoText.Letters
FpSpread1.RowHeader.AutoTextIndex = 0
FpSpread1.RowHeader.Columns(0).BackColor = Color.Red
FpSpread1.Rows(0).Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Yellow, 2)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FpSpread Class
FpSpread Members
Columns Property
Rows Class

User-Task Documentation

Customizing the Appearance of Rows and Columns