Class ExternalLink

Represents an external link in a workbook.

public class ExternalLink

Properties

NameDescription
DataSource { get; set; }Represents data source of the external link.
IsReferred { get; }Indicates whether this external link is referenced by others.
IsVisible { get; }Indicates whether this external link is visible in MS Excel.
OriginalDataSource { get; set; }Represents stored data source of the external link.
PathType { get; }Get the path type of this external link
Type { get; }Gets the type of external link.

Methods

NameDescription
AddExternalName(string, string)Adds an external name.

Examples


[C#]

//Open a file with external links
Workbook workbook = new Workbook("book1.xls");

//Get External Link 
ExternalLink externalLink = workbook.Worksheets.ExternalLinks[0];

//Change External Link's Data Source
externalLink.DataSource = "d:\\link.xls";

[VB.NET]

'Open a file with external links
Dim workbook As New Workbook("book1.xls")

'Get External Link 
Dim externalLink As ExternalLink = workbook.Worksheets.ExternalLinks(0)

'Change External Link's Data Source
externalLink.DataSource = "d:\link.xls"

See Also