v5.20192.624
|

DefinedName Class

Represents the Workbook Object Model Defined Name item definition.

Hierarchy

  • DefinedName

Constructors

Properties

Constructors

constructor

Properties

name

name: string

The name of the defined name item.

sheetName

sheetName: string

Indicates the defined name item works in which sheet. If omitted, the defined name item works in workbook

value

value: any

The value of the defined name item. The value could be a formula, a string constant or a cell range. For e.g. "Sum(1, 2, 3)", "test" or "sheet1!A1:B2"