FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetViewCollection Class : AddRange Method |
'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 )
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.
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);
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6