Insert Method (SheetViewCollection)

Inserts a specified sheet at a specified place in the collection.

Syntax

Visual Basic
C#

'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);

Visual Basic

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)

Reference

SheetViewCollection Class
SheetViewCollection Members