aspose.cells
Class NameCollection

function getCount()

function get(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.

function get(text)

Gets the Name element with the specified name.

Parameters:

text - Name text.

Returns:

The element with the specified name.

function add(text)

Defines a new name.

Name cannot include spaces and cannot look like cell references.

Parameters:

text: String - The text to use as the name.

Returns:

Name object index.

function remove(names)

Remove an array of name

Parameters:

names: String[] - The names' text.

function remove(text)

Remove the name.

Parameters:

text: String - The name text.

function removeAt(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: Number - index of the Name to be removed.

function clear()

Remove all defined names which are not referenced by the formulas and data source. If the defined name is refered, we only set Name.ReferTo as null and hide them.

function removeDuplicateNames()

Remove the duplicate defined names

function 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

function iterator()

function get(index)

Reserved for internal use.

function contains(value)

Reserved for internal use.

function add(value)

Reserved for internal use.

function indexOf(value)

Reserved for internal use.