Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetDataModel Interface / IsRowUsed Method
Row index
Example


In This Topic
    IsRowUsed Method (ISheetDataModel)
    In This Topic
    Determines whether the specified row contains data.
    Syntax
    'Declaration
     
    Function IsRowUsed( _
       ByVal row As Integer _
    ) As Boolean
    'Usage
     
    Dim instance As ISheetDataModel
    Dim row As Integer
    Dim value As Boolean
     
    value = instance.IsRowUsed(row)
    bool IsRowUsed( 
       int row
    )

    Parameters

    row
    Row index

    Return Value

    true if the row contains data; false otherwise
    Example
    This example returns whether the specified row contains data.
    private void ChangeDataModel(FarPoint.Web.Spread.FpSpread ss, FarPoint.Web.Spread.Model.ISheetDataModel isd)
    {
        isd.SetValue(0, 0, "Primary");
        ss.ActiveSheetView.DataModel = (FarPoint.Web.Spread.Model.ISheetDataModel)isd;
        bool b;
        b = isd.IsRowUsed;
        Response.Write("The row used is " & b.ToString());
    }
    
    private void PageLoad(object sender, System.EventArgs e)
    {
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel);    
    }
    
    Private Sub ChangeDataModel(ByVal ss As FarPoint.Web.Spread.FpSpread, ByVal isd As FarPoint.Web.Spread.Model.ISheetDataModel)
        isd.SetValue(0, 0, "Primary")
        ss.ActiveSheetView.DataModel = isd
        Dim b As Boolean
        b = isd.IsRowUsed(0)
        Response.Write("The row used is " & b.ToString())
    End Sub
    
    Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel)
    End Sub
    See Also