Spread for ASP.NET 8.0 Product Documentation
IsRowUsed Method (BaseSheetDataModel)
Example 


Row index
Determines whether the specified row contains data.
Syntax
'Declaration
 
Public Overridable Function IsRowUsed( _
   ByVal row As Integer _
) As Boolean
'Usage
 
Dim instance As BaseSheetDataModel
Dim row As Integer
Dim value As Boolean
 
value = instance.IsRowUsed(row)
public virtual bool IsRowUsed( 
   int row
)

Parameters

row
Row index

Return Value

true if the row contains data; false otherwise
Example
This example checks to see if the specified row contains data.
FarPoint.Web.Spread.Model.BaseSheetDataModel bdm;
bool b;
bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
bdm.SetValue(0, 0, "Test Row Empty");
b = bdm.IsRowUsed(0);
Response.Write("The row used is " + b.ToString());
Dim bdm As FarPoint.web.Spread.Model.BaseSheetDataModel
Dim b As Boolean
bdm = FpSpread1.ActiveSheetView.DataModel
bdm.SetValue(0, 0, "Test Row Empty")
b = bdm.IsRowUsed(0)
Response.Write("The row used is " & b.ToString())
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

Reference

BaseSheetDataModel Class
BaseSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.