AddRange Method (SheetViewCollection)

Visual Basic
C#

'Declaration
 
Public Sub AddRange( _
   ByVal c As ICollection _
)

'Usage
 
Dim instance As SheetViewCollection
Dim c As ICollection
 
instance.AddRange(c)

public void AddRange( 
   ICollection c
)

Parameters

c: Collection of sheets

To add a single sheet to the collection, use the Add method.

For more information about the ICollection, interface refer to the Microsoft .NET Framework Reference.

This example creates two sheets and adds them to the collection of sheets together 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).

C#

System.Collections.ArrayList coll = New System.Collections.ArrayList(2);
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;
coll.Add(sv2);
coll.Add(sv3);
FpSpread1.Sheets.AddRange(coll);

Visual Basic

Dim coll As New System.Collections.ArrayList(2)
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
coll.Add(sv2)
coll.Add(sv3)
FpSpread1.Sheets.AddRange(coll)

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

Reference

SheetViewCollection Class
SheetViewCollection Members
Add Method