Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetDataModel Interface / IsEmpty Method

In This Topic
    IsEmpty Method (ISheetDataModel)
    In This Topic
    Determines whether the model is empty of data.
    Function IsEmpty() As Boolean
    Dim instance As ISheetDataModel
    Dim value As Boolean
    value = instance.IsEmpty()
    bool IsEmpty()

    Return Value

    true if the cell has no data; false otherwise
    This example returns whether the model 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.IsEditable(0, 0);
        Response.Write("The cell can be edited 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.IsEmpty()
        Response.Write("The model is empty 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