Spread for ASP.NET 9.0 Product Documentation
Add Method (SheetViewCollection)
Example 


SheetView object containing the sheet to add to the collection
Adds a sheet to the collection.
Syntax
'Declaration
 
Public Sub Add( _
   ByVal sheetView As SheetView _
) 
'Usage
 
Dim instance As SheetViewCollection
Dim sheetView As SheetView
 
instance.Add(sheetView)
public void Add( 
   SheetView sheetView
)

Parameters

sheetView
SheetView object containing the sheet to add to the collection
Remarks
To add multiple sheets to the collection, use the AddRange method.
Example
This example creates two sheets and adds them to the collection of sheets one at a time so that the total number of sheets now equals three (which includes the one that is added by default and the two added to the collection).
FarPoint.Web.Spread.SheetView sv2 = New FarPoint.Web.Spread.SheetView();
FarPoint.Web.Spread.SheetView sv3 = New FarPoint.Web.Spread.SheetView();
sv2.GridLineColor = Color.Red;
sv2.GridLines = GridLines.Vertical;
sv3.GridLineColor = Color.Yellow;
sv3.GridLines = GridLines.Horizontal;
FpSpread1.Sheets.Add(sv2);
FpSpread1.Sheets.Add(sv3);
Dim sv2 As New FarPoint.Web.Spread.SheetView()
Dim sv3 As New FarPoint.Web.Spread.SheetView()
sv2.GridLineColor = Color.Red
sv2.GridLines = GridLines.Vertical
sv3.GridLineColor = Color.Yellow
sv3.GridLines = GridLines.Horizontal
FpSpread1.Sheets.Add(sv2)
FpSpread1.Sheets.Add(sv3)
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetViewCollection Class
SheetViewCollection Members
AddRange Method

 

 


Copyright © GrapeCity, inc. All rights reserved.