Columns Property (SheetView)

Gets the columns in the data area of the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Columns As Columns

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

public Columns Columns {get;}

Property Value

Columns object with the columns

Remarks

This property is available at run time only.

This allows reference to a column of cells or several columns 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 column.

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Border bord=new FarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2);
sv.Columns[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.Columns(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
Columns Class
Column Class

User-Task Documentation

Customizing the Appearance of Rows and Columns