Click or drag to resize
SheetCollection Methods

The SheetCollection type exposes the following members.

Methods
  NameDescription
Public methodAdd
Creates a new sheet of the specified type and adds it to the collection.
Public methodContains(String)
Determines whether the collection contains a sheet with the specified sheet name.
Public methodContains(Sheet)
Determines whether the sheet collection contains the specified sheet.
Public methodGetByName
Gets a sheet by name.
Public methodGetEnumerator
Returns an enumerator that iterates through the collection.
Public methodIndexOf(String)
Searches for the specified sheet by name and returns the zero-based index of the first occurrence within the SheetCollection. The search is case insensitive.
Public methodIndexOf(Sheet)
Searches for the specified sheet and returns the zero-based index of the first occurrence within the SheetCollection.
Public methodInsert(SheetType)
Creates a new sheet of the specified type and inserts it in the collection at the active sheet index.
Public methodInsert(Int32, SheetType)
Creates a new sheet of the specified type and inserts it in the collection at specified index.
Public methodMove
Moves the specified number of items from the specified index to a specified index.
Protected methodOnActiveSheetChanged
Called when [active sheet changed].
Protected methodOnActiveSheetIndexChanged
Called when [active sheet index changed].
Protected methodOnChanged
Raises the [E:Changed] event.
Public methodRemove
Removes the active sheet.
Public methodRemove(String)
Removes the sheet with the specified name.
Public methodRemove(Sheet)
Removes the specified sheet.
Public methodRemoveAt
Removes the sheet at the specified index.
Top
Extension Methods
  NameDescription
Public Extension MethodAppendSheet(IEnumerableSheet)Overloaded.
Appends elements from two sequences.
(Defined by CollectionExtensions.)
Public Extension MethodAppendSheet(Sheet)Overloaded.
Appends an element to a sequence.
(Defined by CollectionExtensions.)
Public Extension MethodAppendSheet(IEnumerableSheet)Overloaded. (Defined by EnumerableExtensions.)
Public Extension MethodAppendSheet(Sheet)Overloaded. (Defined by EnumerableExtensions.)
Public Extension MethodCloneSheet
Clones the list.
(Defined by CommonExtensions.)
Public Extension MethodContainsAnySheet
Checks for the occurrence of the given items in the collection.
(Defined by CommonExtensions.)
Public Extension MethodForEachSheet
Executes the action for each item in the collection.
(Defined by CommonExtensions.)
Public Extension MethodTakeAfterSheet
Bypasses elements from a sequence as long as a specified condition is true and then returns the remaining elements.
(Defined by CollectionExtensions.)
Public Extension MethodTakeBeforeSheet
Bypasses elements from a sequence until the specified condition becomes true.
(Defined by CollectionExtensions.)
Public Extension MethodTakeBetweenSheet(FuncSheet, Boolean, FuncSheet, Boolean)Overloaded.
Bypasses elements from a sequence as long as the first condition is false. Returns elements from the remaining elements as long the second condition is false.
(Defined by CollectionExtensions.)
Public Extension MethodTakeBetweenSheet(Sheet, Sheet)Overloaded.
Returns elements from a sequence as long as they are between the two items.
(Defined by CollectionExtensions.)
Public Extension MethodTakeFromSheet(FuncSheet, Boolean)Overloaded.
Bypasses elements from a sequence as long as a specified condition is false and then returns the element that satisfies the condition and the elements after.
(Defined by CollectionExtensions.)
Public Extension MethodTakeFromSheet(Sheet)Overloaded.
Bypasses elements from a sequence as long as the element is not equal to the items in the sequence.
(Defined by CollectionExtensions.)
Public Extension MethodTakeToSheet(FuncSheet, Boolean)Overloaded.
Returns elements from a sequence as long as a specified condition is false. This method also returns the first element that satisfies the condition.
(Defined by CollectionExtensions.)
Public Extension MethodTakeToSheet(Sheet)Overloaded.
Returns elements from a sequence as long as the sequence elements differs from the item.
(Defined by CollectionExtensions.)
Top
See Also