Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / Columns Property
Example


In This Topic
    Columns Property (SheetView)
    In This Topic
    Gets the columns in the data area of the sheet.
    Syntax
    '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;
    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
    See Also