Methods

addExternalName(text, referTo)

Adds an external name.

Parameters

Name Type Optional Description

text

String

 

The text of the external name. If the external name belongs to a worksheet, the text should be as Sheet1!Text.

referTo

String

 

The referTo of the external name. It must be a cell or the range.

getDataSource()

Represents data source of the external link.

getOriginalDataSource()

Represents stored data source of the external link.

getType()

Gets the type of external link. The value of the property is ExternalLinkType integer constant.

isReferred()

Indicates whether this external link is referenced by others.

isVisible()

Indicates whether this external link is visible in MS Excel.

setDataSource()

Represents data source of the external link.

setOriginalDataSource()

Represents stored data source of the external link.