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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
Rows Class

User-Task Documentation

Customizing the Appearance of Rows and Columns