Spread Windows Forms 7.0 Product Documentation
IsEmpty Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.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

Boolean: true if every cell in the data model is empty; false otherwise (not one cell empty)

Example

This example returns if the sheet is empty.
C#Copy Code
FarPoint.Win.Spread.Model.ISheetDataModel isd;
bool b;
isd = (FarPoint.Win.Spread.Model.ISheetDataModel)fpSpread1.ActiveSheet.Models.Data;
isd.SetValue(0, 0, "FarPoint");
b = isd.IsEmpty();
label1.Text = "The sheet is empty  = " + b.ToString();
Visual BasicCopy Code
Dim isd As FarPoint.Win.Spread.Model.ISheetDataModel
Dim b As Boolean
isd = FpSpread1.ActiveSheet.Models.Data
isd.SetValue(0, 0, "FarPoint")
b = isd.IsEmpty()
Label1.Text = "The sheet is empty =  " & b.ToString()

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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