Gets an enumerator for iterating to the next cell span in the collection after the specified span.
Syntax
Parameters
- row
- Row index
- column
- Column index
- rowCount
- Number of rows in cell span
- columnCount
- Number of columns in cell span
Return Value
IEnumerator object for enumerating to the next span
Example
This example moves the models enumerator to the next instance.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.ISheetSpanModel sp;
FarPoint.Win.Spread.Model.CellRange cr;
IEnumerator ie;
DialogResult dlg;
sp = (FarPoint.Win.Spread.Model.ISheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
sp.Add(0, 0, 2, 2);
sp.Add(0, 3, 2, 2);
dlg = MessageBox.Show("Do you want to enumerate through the specified span??", "GetEnumerator", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
bool b;
ie = sp.GetEnumerator(0, 3, 2, 2);
b = ie.MoveNext();
if (b == true)
{
cr = (FarPoint.Win.Spread.Model.CellRange)ie.Current;
label1.Text = "The column is " + cr.Column.ToString() + " and the row is " + cr.Row;
}
} |
Visual Basic | Copy Code |
---|
Dim sp As FarPoint.Win.Spread.Model.ISheetSpanModel
Dim cr As FarPoint.Win.Spread.Model.CellRange
Dim ie As IEnumerator
Dim dlg As DialogResult
sp = FpSpread1.ActiveSheet.Models.Span
sp.Add(0, 0, 2, 2)
sp.Add(0, 3, 2, 2)
dlg = MessageBox.Show("Do you want to enumerate through the specified span??", "GetEnumerator", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
Dim b As Boolean
ie = sp.GetEnumerator(0, 3, 2, 2)
b = ie.MoveNext()
If b = True Then
cr = ie.Current()
Label1.Text = "The column is " & cr.Column.ToString() & " and the row is " & cr.Row
End If
End If |
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