Inserts a specified sheet at a specified place in the collection.
Syntax
Parameters
- index
- Index at which to insert a sheet
- sheetView
- Sheet to insert
Example
This example inserts a sheet into the collection.
C# | Copy Code |
---|
FarPoint.Web.Spread.SheetView sv0 = New FarPoint.Web.Spread.SheetView();
FarPoint.Web.Spread.SheetView sv1 = New FarPoint.Web.Spread.SheetView();
sv0.GridLineColor = Color.Red;
sv0.GridLines = GridLines.Vertical;
sv1.GridLineColor = Color.Yellow;
sv1.GridLines = GridLines.Horizontal;
FpSpread1.Sheets.Clear();
FpSpread1.Sheets.Insert(0, sv0);
FpSpread1.Sheets.Insert(1, sv1);
|
Visual Basic | Copy Code |
---|
Dim sv0 As New FarPoint.Web.Spread.SheetView
Dim sv1 As New FarPoint.Web.Spread.SheetView
sv0.GridLineColor = Color.Red
sv0.GridLines = GridLines.Vertical
sv1.GridLineColor = Color.Yellow
sv1.GridLines = GridLines.Horizontal
FpSpread1.Sheets.Clear()
FpSpread1.Sheets.Insert(0, sv0)
FpSpread1.Sheets.Insert(1, sv1) |
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