ExternalLink
Source: aspose.
Represents an external link in a workbook.
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.
getPathType()
Get the path type of this 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.