Insert Method (SheetViewCollection)

Inserts a sheet into the collection at the specified index.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable 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 virtual void Insert( 
   int index,
   SheetView sheetView
)

Parameters

index: Zero-based index at which to insert the sheet
sheetView: Sheet (SheetView object) to insert into the collection

Exceptions

Exception	Description
System.ArgumentNullException	Sheet is not specified (that is, specified sheet is null)

Example

This example inserts a sheet into the collection at the specified index.

FarPoint.Win.Spread.SheetView mySheet = new FarPoint.Win.Spread.SheetView();
fpSpread1.Sheets.Count = 2;
mySheet.ColumnCount = 4;
mySheet.RowCount = 4;
fpSpread1.Sheets.Insert(1, mySheet);
fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;

Visual Basic

Dim mySheet As New FarPoint.Win.Spread.SheetView()
FpSpread1.Sheets.Count = 2
mySheet.ColumnCount = 4
mySheet.RowCount = 4
FpSpread1.Sheets.Insert(1, mySheet)
FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always

Reference

SheetViewCollection Class
SheetViewCollection Members