Gets the index of the last column that contains data or formatting on this sheet.
Syntax
Parameters
- dataFlag
- Whether to look for data or formatting (NonEmptyItemFlag setting)
Return Value
Integer column index of the last column that contains data
Example
This example illustrates the use of this member by returning the last column and row that contains data.
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() & ")" |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also