Spread Windows Forms 9.0 Product Documentation
IsRowUsed Method (DefaultSheetDataModel)
Example 


Specifies whether the row uses a formula, tag, or note.
Overload List
OverloadDescription
IsRowUsed(Int32,Boolean,Boolean,Boolean)Specifies whether the row uses a formula, tag, or note.  
IsRowUsed(Int32)Determines whether the specified row is not empty.  
Example
Dim dt As New DataTable("Testing")
Dim b As Boolean
dt.Columns.Add("Number")
dt.Columns.Add("Letter")
dt.Rows.Add(New Object() {"1", "One"})
dt.Rows.Add(New Object() {"2", "Two"})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheet.Models.Data = dataModel
b = dataModel.IsRowUsed(1)
ListBox1.Items.Add(b.ToString())
DataTable dt = new DataTable("Testing");
bool b;
dt.Columns.Add("Number");
dt.Columns.Add("Letter");
dt.Rows.Add(new Object[]{"1", "One"});
dt.Rows.Add(new Object[] {"2", "Two"});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt);
fpSpread1.ActiveSheet.Models.Data = dataModel;
b = dataModel.IsRowUsed(1);
listBox1.Items.Add(b.ToString());
Requirements

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

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.