ExternalLink
Contents
[
Hide
]ExternalLink class
Represents an external link in a workbook.
class ExternalLink;
Example
const { Workbook } = AsposeCells;
//Open a file with external links
var workbook = new Workbook(data);
//Get External Link
var externalLink = workbook.worksheets.externalLinks.get(0);
//Change External Link's Data Source
externalLink.dataSource = "input/Book1.xls";
Properties
| Property | Type | Description |
|---|---|---|
| type | ExternalLinkType | Readonly. Gets the type of external link. |
| pathType | string | Readonly. 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 | Readonly. Indicates whether this external link is referenced by others. |
| isVisible | boolean | Readonly. Indicates whether this external link is visible in MS Excel. |
Methods
| Method | Description |
|---|---|
| addExternalName(string, string) | Adds an external name. |
type
Readonly. Gets the type of external link.
type : ExternalLinkType;
pathType
Readonly. Get the path type of this external link
pathType : string;
originalDataSource
Represents stored data source of the external link.
originalDataSource : string;
dataSource
Represents data source of the external link.
dataSource : string;
isReferred
Readonly. Indicates whether this external link is referenced by others.
isReferred : boolean;
isVisible
Readonly. Indicates whether this external link is visible in MS Excel.
isVisible : boolean;
addExternalName(string, string)
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. |