Spread ASP.NET 6.0 Product Documentation
Columns Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : Columns Property


Glossary Item Box

Gets the columns in the data area of the sheet.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property Columns As Columns
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As Columns
 
value = instance.Columns
C# 
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#Copy Code
FarPoint.Web.Spread.SheetViewsv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Borderbord=NewFarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2);
sv.Columns[0].Border=bord;
Visual BasicCopy Code
DimsvAsFarPoint.Web.Spread.SheetView
sv=FpSpread1.ActiveSheetView
DimbordAsNewFarPoint.Web.Spread.Border(BorderStyle.Dotted,Color.Teal,2)
sv.Columns(0).Border=bord

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.