ExternalLink
Contents
[
Hide
]ExternalLink class
Represents an external link in a workbook.
Properties
| Name | Type | Description |
|---|---|---|
| Type | Number | Gets the type of external link. The value of the property is ExternalLinkType integer constant. |
| PathType | String | Get the path type of this external link |
| OriginalDataSource | String | Represents stored data source of the external link. |
| DataSource | String | Represents data source of the external link. |
| IsReferred | boolean | Indicates whether this external link is referenced by others. |
| IsVisible | boolean | Indicates whether this external link is visible in MS Excel. |
Methods
| Name | Description |
|---|---|
| addExternalName | Adds an external name. |
ExternalLink.Type property
Gets the type of external link. The value of the property is ExternalLinkType integer constant.
Type: Number
ExternalLink.PathType property
Get the path type of this external link
Type: String
ExternalLink.OriginalDataSource property
Represents stored data source of the external link.
Type: String
ExternalLink.DataSource property
Represents data source of the external link.
Type: String
ExternalLink.IsReferred property
Indicates whether this external link is referenced by others.
Type: boolean
ExternalLink.IsVisible property
Indicates whether this external link is visible in MS Excel.
Type: boolean
addExternalName(text, referTo)
Adds an external name.
| 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. |