ColumnCount Property (SheetView)

Visual Basic
C#

'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

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

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.

C#

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)));
}

Visual Basic

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

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
RowCount Property

User-Task Documentation

Customizing the Number of Rows or Columns