NameCollection

NameCollection class

Represents a collection of all the Name objects in the spreadsheet.

public class NameCollection : CollectionBase<Name>

Properties

Name Description
Capacity { get; set; }
Count { get; }
Item { get; } Gets the Name element at the specified index. (2 indexers)
Item { get; set; }

Methods

Name Description
Add(string) Defines a new name.
BinarySearch(Name)
BinarySearch(Name, IComparer<Name>)
BinarySearch(int, int, Name, IComparer<Name>)
Clear() Remove all defined names which are not referenced by the formulas and data source. If the defined name is referred, we only set Name.ReferTo as null and hide them. (2 methods)
Contains(Name)
CopyTo(Name[])
CopyTo(Name[], int)
CopyTo(int, Name[], int, int)
Exists(Predicate<Name>)
Filter(NameScopeType, int) Gets all defined name by scope.
Find(Predicate<Name>)
FindAll(Predicate<Name>)
FindIndex(Predicate<Name>)
FindIndex(int, Predicate<Name>)
FindIndex(int, int, Predicate<Name>)
FindLast(Predicate<Name>)
FindLastIndex(Predicate<Name>)
FindLastIndex(int, Predicate<Name>)
FindLastIndex(int, int, Predicate<Name>)
GetEnumerator()
IndexOf(Name)
IndexOf(Name, int)
IndexOf(Name, int, int)
LastIndexOf(Name)
LastIndexOf(Name, int)
LastIndexOf(Name, int, int)
Remove(string) Remove the name.
Remove(string[]) Remove an array of name
RemoveAt(int) Remove the name at the specific index. (2 methods)
RemoveDuplicateNames() Remove the duplicate defined names
Sort() Sorts defined names.

See Also