FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread.Model 名前空間 > DefaultSheetStyleModel クラス : IsRowUsed メソッド |
'使用法 Dim instance As DefaultSheetStyleModel Dim row As Integer Dim value As Boolean value = instance.IsRowUsed(row)
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo(); sInfo.BackColor = Color.LightBlue; FarPoint.Win.Spread.Model.DefaultSheetStyleModel ds = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style; int i; for (i = 0; i <= 5; i++) { ds.SetDirectInfo(i, 0, sInfo); } bool b; b = ds.IsRowUsed(2); if (b == true) { MessageBox.Show("The row is used"); }
Dim sInfo As New FarPoint.Win.Spread.StyleInfo sInfo.BackColor = Color.LightBlue Dim ds As FarPoint.Win.Spread.Model.DefaultSheetStyleModel = FpSpread1.ActiveSheet.Models.Style Dim i As Integer For i = 0 To 5 ds.SetDirectInfo(i, 0, sInfo) Next Dim b As Boolean b = ds.IsRowUsed(2) If b = True Then MessageBox.Show("The row is used") End If