Excel.Interfaces.NamedItemCollectionLoadOptions interface

属于工作簿或工作表的所有 NamedItem 对象的集合, 具体取决于它的访问方式。A collection of all the NamedItem objects that are part of the workbook or worksheet, depending on how it was reached.

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

属性

$all
arrayValues

对于集合中的每一项: 返回一个对象, 其中包含已命名项目的值和类型。For EACH ITEM in the collection: Returns an object containing values and types of the named item.

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

comment

对于集合中的每一项: 代表与此名称关联的注释。For EACH ITEM in the collection: Represents the comment associated with this name.

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

formula

对于集合中的每一项: 获取或设置已命名项的公式。For EACH ITEM in the collection: 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

对于集合中的每一项: 对象的名称。For EACH ITEM in the collection: The name of the object. 只读。Read-only.

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

scope

对于集合中的每一项: 指示名称是限定在工作簿中还是特定工作表。For EACH ITEM in the collection: 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

对于集合中的每一项: 指示由名称的公式返回的值的类型。For EACH ITEM in the collection: 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

对于集合中的每一项: 代表由名称的公式计算的值。For EACH ITEM in the collection: 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

对于集合中的每一项: 指定对象是否可见。For EACH ITEM in the collection: Specifies whether the object is visible or not.

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

worksheet

对于集合中的每一项: 返回已命名项目的作用域所在的工作表。For EACH ITEM in the collection: 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

对于集合中的每一项: 返回已命名项目的作用域所在的工作表。For EACH ITEM in the collection: 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

对于集合中的每一项: 返回一个对象, 其中包含已命名项目的值和类型。For EACH ITEM in the collection: 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

对于集合中的每一项: 代表与此名称关联的注释。For EACH ITEM in the collection: Represents the comment associated with this name.

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

comment?: boolean;

属性值

boolean

formula

对于集合中的每一项: 获取或设置已命名项的公式。For EACH ITEM in the collection: 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

对于集合中的每一项: 对象的名称。For EACH ITEM in the collection: The name of the object. 只读。Read-only.

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

name?: boolean;

属性值

boolean

scope

对于集合中的每一项: 指示名称是限定在工作簿中还是特定工作表。For EACH ITEM in the collection: 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

对于集合中的每一项: 指示由名称的公式返回的值的类型。For EACH ITEM in the collection: 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

对于集合中的每一项: 代表由名称的公式计算的值。For EACH ITEM in the collection: 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

对于集合中的每一项: 指定对象是否可见。For EACH ITEM in the collection: Specifies whether the object is visible or not.

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

visible?: boolean;

属性值

boolean

worksheet

对于集合中的每一项: 返回已命名项目的作用域所在的工作表。For EACH ITEM in the collection: 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

对于集合中的每一项: 返回已命名项目的作用域所在的工作表。For EACH ITEM in the collection: 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;

属性值