Copies the sheets in the collection to an array.
Syntax
Parameters
- array
- Array to which to copy the sheets
- arrayIndex
- Array index at which to start pasting the sheets
Example
This example copies the sheets in the collection to an array.
C# | Copy Code |
---|
System.Collections.ArrayList coll = new System.Collections.ArrayList(3);
SheetView Sheet1 = new FarPoint.Win.Spread.SheetView();
SheetView Sheet2 = new FarPoint.Win.Spread.SheetView();
SheetView Sheet3 = new FarPoint.Win.Spread.SheetView();
Object[] myarray = new Object[4];
coll.AddRange(new Object[] {Sheet1, Sheet2, Sheet3});
fpSpread1.Sheets.AddRange(coll);
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
fpSpread1.Sheets.CopyTo(myarray, 0);
listBox1.Items.Add(myarray.GetValue(0).ToString()); |
Visual Basic | Copy Code |
---|
Dim coll As New System.Collections.ArrayList(3)
Dim Sheet1 As New FarPoint.Win.Spread.SheetView()
Dim Sheet2 As New FarPoint.Win.Spread.SheetView()
Dim Sheet3 As New FarPoint.Win.Spread.SheetView()
Dim myarray(3)
coll.AddRange(New Object() {Sheet1, Sheet2, Sheet3})
FpSpread1.Sheets.AddRange(coll)
FpSpread1.TabStripPolicy = TabStripPolicy.Always
FpSpread1.Sheets.CopyTo(myarray, 0)
ListBox1.Items.Add(myarray.GetValue(0).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