ExternalLink Class

Represents an external link in a workbook.
Inheritance Hierarchy
SystemObject
  Aspose.CellsExternalLink

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.6.0.0 (20.6)
Syntax
public class ExternalLink

The ExternalLink type exposes the following members.

Properties
  NameDescription
Public propertyDataSource
Represents data source of the external link.
Public propertyIsReferred
Indicates whether this external link is referenced by others.
Public propertyIsVisible
Indicates whether this external link is visible in MS Excel.
Public propertyOriginalDataSource
Represents stored data source of the external link.
Public propertyType
Gets the type of external link.
Methods
  NameDescription
Public methodAddExternalName
Adds an external name.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Examples
[C#]

//Open a file with external links
Workbook workbook = new Workbook("d:\\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("d:\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