Spread for ASP.NET 7.0 Product Documentation
Insert Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetViewCollection Class : Insert Method


index
Index at which to insert a sheet
sheetView
Sheet to insert

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Sub Insert( _
   ByVal index As Integer, _
   ByVal sheetView As SheetView _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetViewCollection
Dim index As Integer
Dim sheetView As SheetView
 
instance.Insert(index, sheetView)
C# 
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.
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 BasicCopy 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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.