Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / NonEmptyColumnCount Property
Example


In This Topic
    NonEmptyColumnCount Property (DefaultSheetDataModel)
    In This Topic
    Gets the number of columns in the model that contain data (bound or unbound).
    Syntax
    'Declaration
     
    Public Overrides ReadOnly Property NonEmptyColumnCount As Integer
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim value As Integer
     
    value = instance.NonEmptyColumnCount
    public override int NonEmptyColumnCount {get;}

    Property Value

    Integer number that is one more than the index of the last column in the model that contains data
    Remarks
    This property returns a value that is one more than the index of the last column in the model that contains data.
    Example
    This example assigns values to the Spread data model and returns the number of non-empty columns and rows.
    Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)HandlesMyBase.Load
    If(IsPostBack)Then
    Return
    EndIf
    
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,0,"First")
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,1,"Second")
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,2,"Third")
    FpSpread1.ActiveSheetView.DataModel.SetValue(2,0,"Un")
    FpSpread1.ActiveSheetView.DataModel.SetValue(2,1,"Deux")
    FpSpread1.ActiveSheetView.DataModel.SetValue(2,2,"Trois")
    
    DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetDataModel=FpSpread1.ActiveSheetView.DataModel
    ListBox1.Items.Add(Convert.ToString(model.NonEmptyColumnCount))
    ListBox1.Items.Add(Convert.ToString(model.NonEmptyRowCount))
    End Sub
    private void Page_Load(object sender,System.EventArgs e)
    {
    if(this.IsPostBack)return;
    
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,0,"First");
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,1,"Second");
    FpSpread1.ActiveSheetView.DataModel.SetValue(0,2,"Third");
    FpSpread1.ActiveSheetView.DataModel.SetValue(2,0,"Un");
    FpSpread1.ActiveSheetView.DataModel.SetValue(2,1,"Deux");
    FpSpread1.ActiveSheetView.DataModel.SetValue(2,2,"Trois");
    
    FarPoint.Web.Spread.Model.DefaultSheetDataModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
    ListBox1.Items.Add(Convert.ToString(model.NonEmptyColumnCount));
    ListBox1.Items.Add(Convert.ToString(model.NonEmptyRowCount));
    }
    See Also