Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / ColumnCount Property
Example


In This Topic
    ColumnCount Property (SheetView)
    In This Topic
    Gets or sets the number of columns in the sheet.
    Syntax
    'Declaration
     
    Public Overridable Property ColumnCount As Integer
    'Usage
     
    Dim instance As SheetView
    Dim value As Integer
     
    instance.ColumnCount = value
     
    value = instance.ColumnCount
    public virtual int ColumnCount {get; set;}

    Property Value

    Integer number of columns in the sheet
    Remarks

    To get or set the number of rows in the sheet, use the RowCount property.

    Example
    This example places values in all the cells and, in a button click event, returns the type of sort indicator used in the first column in a sheet with only five columns and eight rows.
    private void Page_Load(object sender, System.EventArgs e)
    {
          if (this.IsPostBack) return;
    
          FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
          int i, j;
          sv.ColumnCount = 5;
          sv.PageSize = 8;
          sv.RowCount = 8;
          for (i = 0;  i <= 7; i++)
          {
               for (j = 0; j <= 4; j++)
                    sv.SetValue(i, j, 100 + i);
               sv.SetColumnSortIndicator(j, FarPoint.Web.Spread.Model.SortIndicator.Descending);
          }
          sv.AllowSort = true;        
    }
    
    private void Button1_Click(object sender, System.EventArgs e)
    {    
             FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
             ListBox1.Items.Add(Convert.ToString(sv.ColumnAxisModel.GetSortIndicator(0)));
    }
    
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    
          If (Me.IsPostBack) Then Return
    
          Dim sv As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
          Dim i, j As Integer
          sv.ColumnCount = 5
          sv.PageSize = 8
          sv.RowCount = 8
          For i = 0 To sv.RowCount - 1
               For j = 0 To sv.ColumnCount
                    sv.SetValue(i, j, 100 + i)
                    sv.SetColumnSortIndicator(j, FarPoint.Web.Spread.Model.SortIndicator.Descending)
               Next j
          Next i
          sv.AllowSort = True
    
    End Sub
    
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
             Dim sv As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
             ListBox1.Items.Add(Convert.ToString(sv.ColumnAxisModel.GetSortIndicator(0)))
    End Sub
    
    See Also