Excel.Interfaces.NamedItemLoadOptions interface

表示单元格区域或值的定义名称。Represents a defined name for a range of cells or value. 名称可以是命名为对象的基元 (如下面的类型中所示)、range 对象或对区域的引用。Names can be primitive named objects (as seen in the type below), range object, or a reference to a range. 此对象可用于获取与名称相关的 range 对象。This object can be used to obtain range object associated with names.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

属性

$all
arrayValues

返回包含已命名项目的值和类型的对象。Returns an object containing values and types of the named item.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

comment

表示与此名称相关联的注释。Represents the comment associated with this name.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

formula

获取或设置的已命名项目的公式。Gets or sets the formula of the named item. 公式始终以等号 (=) 开头。Formula always starts with a '=' sign.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

name

对象的名称。The name of the object. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

scope

指明是否将 name 限定到工作簿或特定工作表。Indicates whether the name is scoped to the workbook or to a specific worksheet. 可能的值为: 工作表、工作簿。Possible values are: Worksheet, Workbook. 只读。Read-only.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

type

指明 name 公式返回的值的类型。Indicates the type of the value returned by the name's formula. 有关详细信息, 请参阅 NamedItemType。See Excel.NamedItemType for details. 只读。Read-only.

[API 集: 字符串、整型、双精度、布尔值、范围、错误的 ExcelApi 1.1、数组的 1.7][ API set: ExcelApi 1.1 for String,Integer,Double,Boolean,Range,Error; 1.7 for Array ]

value

表示 name 公式计算出的值。Represents the value computed by the name's formula. 对于已命名区域,将返回区域地址。For a named range, will return the range address. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

visible

指定对象是否可见。Specifies whether the object is visible or not.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

worksheet

返回已命名项限定到的工作表。Returns the worksheet on which the named item is scoped to. 如果项目的作用域改为工作簿, 则会引发错误。Throws an error if the item is scoped to the workbook instead.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

worksheetOrNullObject

返回已命名项限定到的工作表。Returns the worksheet on which the named item is scoped to. 如果项改为限定到工作簿,将返回 NULL 对象。Returns a null object if the item is scoped to the workbook instead.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

arrayValues

返回包含已命名项目的值和类型的对象。Returns an object containing values and types of the named item.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

arrayValues?: Excel.Interfaces.NamedItemArrayValuesLoadOptions;

属性值

comment

表示与此名称相关联的注释。Represents the comment associated with this name.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

comment?: boolean;

属性值

boolean

formula

获取或设置的已命名项目的公式。Gets or sets the formula of the named item. 公式始终以等号 (=) 开头。Formula always starts with a '=' sign.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

formula?: boolean;

属性值

boolean

name

对象的名称。The name of the object. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

name?: boolean;

属性值

boolean

scope

指明是否将 name 限定到工作簿或特定工作表。Indicates whether the name is scoped to the workbook or to a specific worksheet. 可能的值为: 工作表、工作簿。Possible values are: Worksheet, Workbook. 只读。Read-only.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

scope?: boolean;

属性值

boolean

type

指明 name 公式返回的值的类型。Indicates the type of the value returned by the name's formula. 有关详细信息, 请参阅 NamedItemType。See Excel.NamedItemType for details. 只读。Read-only.

[API 集: 字符串、整型、双精度、布尔值、范围、错误的 ExcelApi 1.1、数组的 1.7][ API set: ExcelApi 1.1 for String,Integer,Double,Boolean,Range,Error; 1.7 for Array ]

type?: boolean;

属性值

boolean

value

表示 name 公式计算出的值。Represents the value computed by the name's formula. 对于已命名区域,将返回区域地址。For a named range, will return the range address. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

value?: boolean;

属性值

boolean

visible

指定对象是否可见。Specifies whether the object is visible or not.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

visible?: boolean;

属性值

boolean

worksheet

返回已命名项限定到的工作表。Returns the worksheet on which the named item is scoped to. 如果项目的作用域改为工作簿, 则会引发错误。Throws an error if the item is scoped to the workbook instead.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

属性值

worksheetOrNullObject

返回已命名项限定到的工作表。Returns the worksheet on which the named item is scoped to. 如果项改为限定到工作簿,将返回 NULL 对象。Returns a null object if the item is scoped to the workbook instead.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

worksheetOrNullObject?: Excel.Interfaces.WorksheetLoadOptions;

属性值