INamedRange Interface |
Represents a defined name for a range of cells. Names can be
either built-in names such as Database, Print_Area, and
Auto_Open or custom names.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The INamedRange type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
Index |
Returns the index number of the object within the collection of similar
objects. Read-only Long.
|
|
|
IsLocal |
Indicates whether name is local.
|
|
|
Name |
Returns or sets the name of the object. Read / write String.
|
|
|
NameLocal |
Returns or sets the name of the object, in the language of the user.
Read / write String for Name.
|
|
|
Parent |
Gets the parent object of the current instance.
(Inherited from
IExcelApplication
.)
|
|
|
RefersToRange |
Returns the Range object referred to by a Name object. Read-only.
|
|
|
Scope |
Returns string representation of the name's scope. Read-only.
|
|
|
Value |
For the Name object, a string containing the formula that the name is
defined to refer to. The string is in A1-style notation in the language
of the macro, and it begins with an equal sign.
|
|
|
ValueR1C1 |
Gets named range formula in R1C1 style. Read only.
|
|
|
Visible |
Determines whether the object is visible. Read / write Boolean.
|
|
|
Worksheet |
Returns parent worksheet. Read-only.
|
Methods
See Also
