Visual Basic (Declaration) | |
---|---|
Public Enum NonEmptyItemFlag Inherits System.Enum |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As NonEmptyItemFlag |
C# | |
---|---|
public enum NonEmptyItemFlag : System.Enum |
Member | Description |
---|---|
Data | [1] Indicates that a cell contains data |
Style | [2] Indicates that a cell contains formatting information |
C# | Copy Code |
---|---|
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() + ")"; |
Visual Basic | Copy Code |
---|---|
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
FarPoint.Win.Spread NamespaceGetLastNonEmptyColumn Method (SheetView Class)
GetLastNonEmptyRow Method (SheetView Class)
NonEmptyColumnCount Property (SheetView Class)
NonEmptyRowCount Property (SheetView Class)
INonEmptyCells Interface