Spread for ASP.NET 11 Product Documentation
Insert Method (SheetViewCollection)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetViewCollection Class : Insert Method
Index at which to insert a sheet
Sheet to insert
Inserts a specified sheet at a specified place in the collection.
Syntax
'Declaration
 
Public Sub Insert( _
   ByVal index As Integer, _
   ByVal sheetView As SheetView _
) 
'Usage
 
Dim instance As SheetViewCollection
Dim index As Integer
Dim sheetView As SheetView
 
instance.Insert(index, sheetView)
public void Insert( 
   int index,
   SheetView sheetView
)

Parameters

index
Index at which to insert a sheet
sheetView
Sheet to insert
Example
This example inserts a sheet into the collection.
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);
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)
See Also

Reference

SheetViewCollection Class
SheetViewCollection Members