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 span
- columnCount
- Number of columns in span
Return Value
IEnumerator object for enumerating through the spans
Example
This example adds spans to the SpanModel of the active sheet. The GetEnumerator method returns those spans to a list box.
C# | Copy Code |
---|
private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FarPoint.Web.Spread.Model.DefaultSheetSpanModel model=(FarPoint.Web.Spread.Model.DefaultSheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
model.Add(0,0,2,1);
model.Add(0,2,3,2);
System.Collections.IEnumerator ien=model.GetEnumerator(0,0,10,10);
bool b1=ien.MoveNext();
while(b1)
{
FarPoint.Web.Spread.Model.CellRange cr=(FarPoint.Web.Spread.Model.CellRange)ien.Current;
ListBox1.Items.Add(cr.ToString());
b1=ien.MoveNext();
}
} |
Visual Basic | Copy Code |
---|
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
If(IsPostBack)Then Return
Dim cr As FarPoint.Web.Spread.Model.CellRange
Dim b1 As Boolean
Dim ien As System.Collections.IEnumerator
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
Dim model As FarPoint.Web.Spread.Model.DefaultSheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
model.Add(0,0,2,1)
model.Add(0,2,3,2)
ien=model.GetEnumerator(0,0,10,10)
b1=ien.MoveNext()
While(b1)
cr=CType(ien.Current,FarPoint.Web.Spread.Model.CellRange)
ListBox1.Items.Add(cr.ToString())
b1=ien.MoveNext
End While
End Sub |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also