Copies the sheets in the collection to an array.
Syntax
Parameters
- array
- Array into which to copy the sheets
- arrayIndex
- Array index at which to start pasting the sheets
Example
This example creates two SheetView objects, adds them to the current sheet and then copies the sheets to an array.
C# | Copy Code |
---|
FarPoint.Web.Spread.SheetView[] myarray = New FarPoint.Web.Spread.SheetView[2];
FarPoint.Web.Spread.SheetView sv1 = New FarPoint.Web.Spread.SheetView();
FarPoint.Web.Spread.SheetView sv2 = New FarPoint.Web.Spread.SheetView();
sv1.GridLineColor = Color.Red;
sv1.GridLines = GridLines.Vertical;
sv2.GridLineColor = Color.Yellow;
sv2.GridLines = GridLines.Horizontal;
FpSpread1.Sheets.Add(sv1);
FpSpread1.Sheets.Add(sv2);
FpSpread1.Sheets.CopyTo(myarray, 0);
|
Visual Basic | Copy Code |
---|
Dim myarray(2) As FarPoint.Web.Spread.SheetView
Dim sv1 As New FarPoint.Web.Spread.SheetView()
Dim sv2 As New FarPoint.Web.Spread.SheetView()
sv1.GridLineColor = Color.Red
sv1.GridLines = GridLines.Vertical
sv2.GridLineColor = Color.Yellow
sv2.GridLines = GridLines.Horizontal
FpSpread1.Sheets.Add(sv1)
FpSpread1.Sheets.Add(sv2)
FpSpread1.Sheets.CopyTo(myarray, 0)
|
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