NativeExcel for .Net Developer's Reference

INames Interface

A collection of all the defined name objects in the IWorkbook or IWorksheet. Each IName interface represents a defined name for a range of cells.

For a list of all members of this type, see INames Members.

[Visual Basic]
public__gc__interfaceINames: publicIEnumerable


Use IWorkbook.Names or IWorksheet.Names property to return the Names collection.

Use the INames.Add method to create a name and add it to the collection.

The Add method's RefersTo argument must be specified in A1-style notation, including dollar signs ($) where appropriate. For example, if cell A10 is selected on Sheet1 and you define a name by using the RefersTo argument "=sheet1!A1:B1", the new name actually refers to cells A10:B10 because you specified a relative reference). To specify an absolute reference, use "=sheet1!$A$1:$B$1".

Use Names[index], where index is the name index number or defined name, to return a single Name object.


Namespace: NativeExcel

Assembly: NativeExcel (in NativeExcel.dll)

See Also

INames Members | NativeExcel Namespace | IWorksheet.Names property | IWorkbook.Names property | IName interface