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


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

    Property Value

    Integer number that is one more than the index of the last row in the model that contains data
    Remarks

    This property returns a value that is one more than the index of the last row 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