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


In This Topic
    ColumnCount Property (BaseSheetDataModel)
    In This Topic
    Gets or sets the number of columns.
    Syntax
    'Declaration
     
    Public Overridable Property ColumnCount As Integer
    'Usage
     
    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
    Example
    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