IsRowUsed Method (DefaultSheetDataModel)

Specifies whether the row uses a formula, tag, or note.

Overload List

Overload	Description
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

Visual Basic

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members