ExternalLink

ExternalLink class

Represents an external link in a workbook.

class ExternalLink;

Method	Description
getType()	Gets the type of external link.
getPathType()	Get the path type of this external link
getOriginalDataSource()	Represents stored data source of the external link.
setOriginalDataSource(string)	Represents stored data source of the external link.
getDataSource()	Represents data source of the external link.
setDataSource(string)	Represents data source of the external link.
isReferred()	Indicates whether this external link is referenced by others.
isVisible()	Indicates whether this external link is visible in MS Excel.
addExternalName(string, string)	Adds an external name.

Gets the type of external link.

getType() : ExternalLinkType;

Returns

ExternalLinkType

Get the path type of this external link

getPathType() : string;

Represents stored data source of the external link.

getOriginalDataSource() : string;

Represents stored data source of the external link.

setOriginalDataSource(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

Represents data source of the external link.

getDataSource() : string;

Represents data source of the external link.

setDataSource(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

Indicates whether this external link is referenced by others.

isReferred() : boolean;

Indicates whether this external link is visible in MS Excel.

isVisible() : boolean;

Adds an external name.

addExternalName(text: string, referTo: string) : void;

Parameters:

Parameter	Type	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.