| FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 : NonEmptyItemFlag 列挙体 |
'Declaration Public Enum NonEmptyItemFlag Inherits System.Enum
'使用法 Dim instance As NonEmptyItemFlag
public enum NonEmptyItemFlag : System.Enum
| メンバ | 説明 |
|---|---|
| Data | ［1］セルにデータが含まれていることを表します。 |
| Style | ［2］セルに書式情報が含まれていることを表します。 |
int i, j; fpSpread1.Columns[2].CellType = new FarPoint.Win.Spread.CellType.DateTimeCellType(); for( i = 0; i < 10; i++ ) fpSpread1.ActiveSheet.SetValue(i, 0, i + 1); j = 0; for( i = 106; i > 96; i-- ) { fpSpread1.ActiveSheet.SetValue(j, 1, Convert.ToChar(i)); j += 1; } System.DateTime mydate = System.DateTime.Now; for( i = 0; i < 10; i++ ) fpSpread1.ActiveSheet.SetValue(i, 2, mydate.AddDays(i)); label1.Text = "The last non-empty column and row is: Column( " + fpSpread1.ActiveSheet.GetLastNonEmptyColumn(FarPoint.Win.Spread.NonEmptyItemFlag.Data).ToString() + ") - Row(" + fpSpread1.ActiveSheet.GetLastNonEmptyRow(FarPoint.Win.Spread.NonEmptyItemFlag.Data).ToString() + ")";
Dim i As Integer, j As Integer FpSpread1.ActiveSheet.Columns(2).CellType = New FarPoint.Win.Spread.CellType.DateTimeCellType() For i = 0 To 9 FpSpread1.ActiveSheet.SetValue(i, 0, i + 1) Next j = 0 For i = 106 To 97 Step -1 FpSpread1.ActiveSheet.SetValue(j, 1, Convert.ToChar(i)) j += 1 Next Dim mydate As DateTime = Now For i = 0 To 9 FpSpread1.ActiveSheet.SetValue(i, 2, mydate.AddDays(i)) Next Label1.Text = "The last non-empty column and row is: Column( " & FpSpread1.ActiveSheet.GetLastNonEmptyColumn(FarPoint.Win.Spread.NonEmptyItemFlag.Data).ToString() & ") - Row(" & FpSpread1.ActiveSheet.GetLastNonEmptyRow(FarPoint.Win.Spread.NonEmptyItemFlag.Data).ToString() & ")"
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.NonEmptyItemFlag