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


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

Reference

SheetViewCollection Class
SheetViewCollection Members

 

 


Copyright © GrapeCity, inc. All rights reserved.