Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / BaseSheetDataModel Class / ColumnCount Property

In This Topic
    ColumnCount Property (BaseSheetDataModel)
    In This Topic
    Gets or sets the number of columns.
    Public Overridable Property ColumnCount As Integer
    Dim instance As BaseSheetDataModel
    Dim value As Integer
    instance.ColumnCount = value
    value = instance.ColumnCount
    public virtual int ColumnCount {get; set;}

    Property Value

    Integer number of columns in the data model
    This example illustrates the use of this member by returning and displays the number of columns and rows that contain data.
    FarPoint.Win.Spread.Model.BaseSheetDataModel dataModel;
    int c, r;
    dataModel = (FarPoint.Win.Spread.Model.BaseSheetDataModel)fpSpread1.ActiveSheet.Models.Data;
    dataModel.ColumnCount = 5;
    dataModel.RowCount = 5;
    dataModel.SetValue(0, 0, "Not Empty");
    c = dataModel.NonEmptyColumnCount;
    r = dataModel.NonEmptyRowCount;
    listBox1.Items.AddRange(new object[] {c.ToString(), r.ToString()});
    Dim dataModel As FarPoint.Win.Spread.Model.BaseSheetDataModel
    Dim c, r As Integer
    dataModel = fpSpread1.ActiveSheet.Models.Data
    dataModel.ColumnCount = 5
    dataModel.RowCount = 5
    dataModel.SetValue(0, 0, "Not Empty")
    c = dataModel.NonEmptyColumnCount
    r = dataModel.NonEmptyRowCount
    ListBox1.Items.AddRange(New Object() {c.ToString(), r.ToString()})
    See Also