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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
