CopyTo(Array,Int32) Method

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Sub CopyTo( _
   ByVal array As Array, _
   ByVal index As Integer _
)

'Usage
 
Dim instance As NamedStyleCollection
Dim array As Array
Dim index As Integer
 
instance.CopyTo(array, index)

public virtual void CopyTo( 
   Array array,
   int index
)

Parameters

array: One-dimensional array into which are copied the elements from ICollection (The array must have zero-based indexing.)
index: Zero-based index in array at which to paste styles

Exception	Description
System.ArgumentNullException	No array specified, or specified array is null (Nothing)
System.ArgumentException	Specified array is not valid; must have a rank of one
System.ArgumentException	Specified array is not valid; must have sufficient length
System.IndexOutOfRangeException	Specified index is out of range; must be greater than zero

This example copies a style to an array at the specified index.

C#

FarPoint.Web.Spread.NamedStyleCollection nsc = new FarPoint.Web.Spread.NamedStyleCollection();
FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault");
FarPoint.Web.Spread.NamedStyle ns1 = new FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault");
ns.BackColor = Color.Yellow;
ns.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue);
ns1.BackColor = Color.Teal;
ns1.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red);
nsc.AddRange(new Object[] {ns, ns1});
object[] c = new Object[nsc.Count];
nsc.CopyTo(c, 0);
FpSpread1.NamedStyles.Add((FarPoint.Web.Spread.NamedStyle)c[0]);
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = (FarPoint.Web.Spread.NamedStyle)c[0];

Visual Basic

Dim nsc As New FarPoint.Web.Spread.NamedStyleCollection
Dim ns As New FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault")
Dim ns1 As New FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault")
ns.BackColor = Color.Yellow
ns.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue)
ns1.BackColor = Color.Teal
ns1.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red)
nsc.AddRange(New Object() {ns, ns1})
Dim c(nsc.Count)
nsc.CopyTo(c, 0)
FpSpread1.NamedStyles.Add(c(0))
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = c(0)

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

Reference

NamedStyleCollection Class
NamedStyleCollection Members
Overload List