Class ExternalLink
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Represents an external link in a workbook.
public class ExternalLinkInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Examples
csharp
[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";
'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"Properties
DataSource
Represents data source of the external link.
public string DataSource { get; set; }Property Value
IsReferred
Indicates whether this external link is referenced by others.
public bool IsReferred { get; }Property Value
IsVisible
Indicates whether this external link is visible in MS Excel.
public bool IsVisible { get; }Property Value
OriginalDataSource
Represents stored data source of the external link.
public string OriginalDataSource { get; set; }Property Value
PathType
Get the path type of this external link
public string PathType { get; }Property Value
Type
Gets the type of external link.
public ExternalLinkType Type { get; }Property Value
Methods
AddExternalName(string, string)
Adds an external name.
public void AddExternalName(string text, string referTo)Parameters
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.