Rows Property (SheetView)

Gets the rows in the data area of the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Rows As Rows

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

public Rows Rows {get;}

Property Value

Rows object with the rows

Remarks

This property is available at run time only.

This property allows reference to a row of cells or several rows of cells in the sheet.

Example

This example assigns a SheetView object to the active sheet and puts a border around all the cells in the first row.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2);
sv.Rows[0].Border=bord;

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv=FpSpread1.ActiveSheetView
Dim bord As New FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2)
sv.Rows(0).Border=bord

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

SheetView Class
SheetView Members
Rows Class

User-Task Documentation

Customizing the Appearance of Rows and Columns