ExternalLink
ExternalLink class
Represents an external link in a workbook.
class ExternalLink;
Example
const { Workbook } = require("aspose.cells.node");
//Open a file with external links
var workbook = new Workbook("input/Externlink.xls");
//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 |
|---|---|
| getType() | @deprecated. Please use the ’type’ property instead. Gets the type of external link. |
| getPathType() | @deprecated. Please use the ‘pathType’ property instead. Get the path type of this external link |
| getOriginalDataSource() | @deprecated. Please use the ‘originalDataSource’ property instead. Represents stored data source of the external link. |
| setOriginalDataSource(string) | @deprecated. Please use the ‘originalDataSource’ property instead. Represents stored data source of the external link. |
| getDataSource() | @deprecated. Please use the ‘dataSource’ property instead. Represents data source of the external link. |
| setDataSource(string) | @deprecated. Please use the ‘dataSource’ property instead. Represents data source of the external link. |
| isReferred() | @deprecated. Please use the ‘isReferred’ property instead. Indicates whether this external link is referenced by others. |
| isVisible() | @deprecated. Please use the ‘isVisible’ property instead. Indicates whether this external link is visible in MS Excel. |
| addExternalName(string, string) | Adds an external name. |
| isNull() | Checks whether the implementation object is null. |
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;
getType()
@deprecated. Please use the ’type’ property instead. Gets the type of external link.
getType() : ExternalLinkType;
Returns
getPathType()
@deprecated. Please use the ‘pathType’ property instead. Get the path type of this external link
getPathType() : string;
getOriginalDataSource()
@deprecated. Please use the ‘originalDataSource’ property instead. Represents stored data source of the external link.
getOriginalDataSource() : string;
setOriginalDataSource(string)
@deprecated. Please use the ‘originalDataSource’ property instead. Represents stored data source of the external link.
setOriginalDataSource(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getDataSource()
@deprecated. Please use the ‘dataSource’ property instead. Represents data source of the external link.
getDataSource() : string;
setDataSource(string)
@deprecated. Please use the ‘dataSource’ property instead. Represents data source of the external link.
setDataSource(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
isReferred()
@deprecated. Please use the ‘isReferred’ property instead. Indicates whether this external link is referenced by others.
isReferred() : boolean;
isVisible()
@deprecated. Please use the ‘isVisible’ property instead. 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. |
isNull()
Checks whether the implementation object is null.
isNull() : boolean;