Gets the index of the next column in a specified row that contains data.
Syntax
Parameters
- row
- Row index to search
- column
- Column index before the column to start searching (-1 to start at column 0)
Return Value
Integer column index for the next cell in the row containing a value, or -1 if no columns contain a value
Example
This example returns the next column with data in the specified row.
C# | Copy Code |
---|
Random r = new Random();
int i, j;
for (i = 1; i <= 50; i++)
{
for (j = 1; j <= 3; j++)
{
fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString());
}
}
FarPoint.Win.Spread.Model.BaseSheetDataModel bsm;
bsm = (FarPoint.Win.Spread.Model.BaseSheetDataModel)fpSpread1.ActiveSheet.Models.Data;
MessageBox.Show(bsm.NextNonEmptyColumnInRow(1, -1).ToString());
|
Visual Basic | Copy Code |
---|
Dim r As New Random
Dim i, j As Integer
For i = 1 To 50
For j = 1 To 3
FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString())
Next j
Next i
Dim bsm As FarPoint.Win.Spread.Model.BaseSheetDataModel
bsm = FpSpread1.ActiveSheet.Models.Data
MessageBox.Show(bsm.NextNonEmptyColumnInRow(1, -1).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