com.aspose.cells
Class NameCollection

java.lang.Object
  CollectionBase
      com.aspose.cells.NameCollection

All Implemented Interfaces:

java.lang.Iterable

public class NameCollection 
extends CollectionBase

public int getCount()

public Name get(int index)

Gets the Name element at the specified index.

Parameters:

index - The zero based index of the element.

Returns:

The element at the specified index.

public Name get(java.lang.String text)

Gets the Name element with the specified name.

Parameters:

text - Name text.

Returns:

The element with the specified name.

public int add(java.lang.String text)

Defines a new name.

Name cannot include spaces and cannot look like cell references.

Parameters:

text - The text to use as the name.

Returns:

Name object index.

public com.aspose.cells.Name[] filter(int type, int sheetIndex)

Gets all defined name by scope.

Parameters:

type - A NameScopeType value. The scope type.

sheetIndex - The sheet index. Only effects when scope type is NameScopeType.WORKSHEET

Returns:

public void remove(java.lang.String[] names)

Remove an array of name

Parameters:

names - The names' text.

public void remove(java.lang.String text)

Remove the name.

Parameters:

text - The name text.

public void removeAt(int index)

Remove the name at the specific index.

Please make sure that the name is not referred by the other formulas before calling the method. And if the name is referred, setting Name.RefersTo as null is better.

Parameters:

index - index of the Name to be removed.

public void 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.

public void removeDuplicateNames()

Remove the duplicate defined names

public void sort()

Sorts defined names.

If you create a large amount of named ranges in the Excel file, please call this method after all named ranges are created and before saving

public java.util.Iterator iterator()

public boolean contains(java.lang.Object value)

Reserved for internal use.

public int add(java.lang.Object value)

Reserved for internal use.

public int indexOf(java.lang.Object value)

Reserved for internal use.