Class CalcSheetList

Wrapper ArrayList that holds a collection of CalcSheets.

Inheritance
System.Object
System.Collections.ArrayList
CalcSheetList
Implements
System.Collections.IList
System.Collections.ICollection
System.Collections.IEnumerable
System.ICloneable
Inherited Members
System.Collections.ArrayList.Adapter(System.Collections.IList)
System.Collections.ArrayList.AddRange(System.Collections.ICollection)
System.Collections.ArrayList.BinarySearch(System.Int32, System.Int32, System.Object, System.Collections.IComparer)
System.Collections.ArrayList.BinarySearch(System.Object)
System.Collections.ArrayList.BinarySearch(System.Object, System.Collections.IComparer)
System.Collections.ArrayList.Capacity
System.Collections.ArrayList.Clear()
System.Collections.ArrayList.Clone()
System.Collections.ArrayList.Contains(System.Object)
System.Collections.ArrayList.CopyTo(System.Array)
System.Collections.ArrayList.CopyTo(System.Array, System.Int32)
System.Collections.ArrayList.CopyTo(System.Int32, System.Array, System.Int32, System.Int32)
System.Collections.ArrayList.Count
System.Collections.ArrayList.FixedSize(System.Collections.ArrayList)
System.Collections.ArrayList.FixedSize(System.Collections.IList)
System.Collections.ArrayList.GetEnumerator()
System.Collections.ArrayList.GetEnumerator(System.Int32, System.Int32)
System.Collections.ArrayList.GetRange(System.Int32, System.Int32)
System.Collections.ArrayList.IndexOf(System.Object)
System.Collections.ArrayList.IndexOf(System.Object, System.Int32)
System.Collections.ArrayList.IndexOf(System.Object, System.Int32, System.Int32)
System.Collections.ArrayList.IsFixedSize
System.Collections.ArrayList.IsReadOnly
System.Collections.ArrayList.IsSynchronized
System.Collections.ArrayList.LastIndexOf(System.Object)
System.Collections.ArrayList.LastIndexOf(System.Object, System.Int32)
System.Collections.ArrayList.LastIndexOf(System.Object, System.Int32, System.Int32)
System.Collections.ArrayList.ReadOnly(System.Collections.ArrayList)
System.Collections.ArrayList.ReadOnly(System.Collections.IList)
System.Collections.ArrayList.RemoveRange(System.Int32, System.Int32)
System.Collections.ArrayList.Repeat(System.Object, System.Int32)
System.Collections.ArrayList.Reverse()
System.Collections.ArrayList.Reverse(System.Int32, System.Int32)
System.Collections.ArrayList.SetRange(System.Int32, System.Collections.ICollection)
System.Collections.ArrayList.Sort()
System.Collections.ArrayList.Sort(System.Collections.IComparer)
System.Collections.ArrayList.Sort(System.Int32, System.Int32, System.Collections.IComparer)
System.Collections.ArrayList.Synchronized(System.Collections.ArrayList)
System.Collections.ArrayList.Synchronized(System.Collections.IList)
System.Collections.ArrayList.SyncRoot
System.Collections.ArrayList.ToArray(System.Type)
System.Collections.ArrayList.TrimToSize()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.Calculate
Assembly: Syncfusion.Calculate.Base.dll
Syntax
public class CalcSheetList : ArrayList, IList, ICollection, IEnumerable, ICloneable

Constructors

CalcSheetList()

Default constructor.

Declaration
public CalcSheetList()

CalcSheetList(CalcSheet[], CalcWorkbook)

Creates an CalcSheetList instance owned by the given workbook with the given CalcSheet list.

Declaration
public CalcSheetList(CalcSheet[] list, CalcWorkbook parentWorkBook)
Parameters
Type Name Description
CalcSheet[] list

list of CalcSheets
CalcWorkbook parentWorkBook

The Workbook

Properties

Item[Int32]

Gets or sets the CalcSheet at the given index.

Declaration
public CalcSheet this[int i] { get; set; }
Parameters
Type Name Description
System.Int32 i

The sheet index.
Property Value
Type
CalcSheet

Item[String]

Gets or sets the CalcSheet with a given name.

Declaration
public CalcSheet this[string sheetName] { get; set; }
Parameters
Type Name Description
System.String sheetName

The sheet name.
Property Value
Type
CalcSheet

Methods

Add(Object)

A method that adds a new CalcSheet.

Declaration
public int Add(object o)
Parameters
Type Name Description
System.Object o

The CalcSheet to be added.
Returns
Type Description
System.Int32

The index of the added CalcSheet.

Insert(Int32, Object)

Not supported.

Declaration
public void Insert(int index, object o)
Parameters
Type Name Description
System.Int32 index
System.Object o

InsertRange(Int32, ICollection)

Not supported.

Declaration
public void InsertRange(int index, ICollection c)
Parameters
Type Name Description
System.Int32 index
System.Collections.ICollection c

NameToIndex(String)

Returns the index for a CalcSheet.

Declaration
public int NameToIndex(string sheetName)
Parameters
Type Name Description
System.String sheetName

The name of the CalcSheet.
Returns
Type Description
System.Int32

The index of the CalcSheet.

Remove(Object)

A method that removes a CalcSheet.

Declaration
public void Remove(object o)
Parameters
Type Name Description
System.Object o

The CalcSheet to be removed.

RemoveAt(Int32)

Removes a CalcSheet.

Declaration
public void RemoveAt(int index)
Parameters
Type Name Description
System.Int32 index

The index of the CalcSheet to be removed.

ToArray()

The CalcSheets in this collection.

Declaration
public CalcSheet[] ToArray()
Returns
Type Description
CalcSheet[]

Returns a CalcSheet[].

Implements

System.Collections.IList
System.Collections.ICollection
System.Collections.IEnumerable
System.ICloneable

Extension Methods