Spread for ASP.NET 7.0 Product Documentation
IsEmpty Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > ISheetDataModel Interface : IsEmpty Method


Glossary Item Box

Determines whether the model is empty of data.

Syntax

Visual Basic (Declaration) 
Function IsEmpty() As Boolean
Visual Basic (Usage)Copy Code
Dim instance As ISheetDataModel
Dim value As Boolean
 
value = instance.IsEmpty()
C# 
bool IsEmpty()

Return Value

true if the cell has no data; false otherwise

Example

This example returns whether the model contains data.
C#Copy Code
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);    
}
Visual BasicCopy Code
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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.