Columns Property (SheetView)

In This Topic

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.

C#
Visual Basic

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;

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

Reference

SheetView Class
SheetView Members
Columns Class
Column Class

User-Task Documentation

Customizing the Appearance of Rows and Columns