Spread Windows Forms 6.0 Product Documentation
IsRowUsed Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetDataModel Interface : IsRowUsed Method


row
Row index

Glossary Item Box

Determines whether the specified row contains data.

Syntax

Visual Basic (Declaration) 
Function IsRowUsed( _
   ByVal row As Integer _
) As Boolean
Visual Basic (Usage)Copy Code
Dim instance As ISheetDataModel
Dim row As Integer
Dim value As Boolean
 
value = instance.IsRowUsed(row)
C# 
bool IsRowUsed( 
   int row
)

Parameters

row
Row index

Return Value

Boolean: true if the row contains data; false otherwise

Example

This example returns if the specified row contains data.
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.IsRowUsed(0);
label1.Text = "The row has data  = " + 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.IsRowUsed(0)
Label1.Text = "The row has data =  " & b.ToString()

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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