aspose.cells
Class ExternalLink

//Open a file with external links
$workbook = new cells\Workbook("book1.xls");
//Get External Link 
$externalLink = $workbook->getWorksheets()->getExternalLinks()->get(0);
//Change External Link's Data Source
$externalLink->setDataSource("link.xls");

function getType()

Gets the type of external link. The value of the property is ExternalLinkType integer constant.

function getOriginalDataSource() / function setOriginalDataSource(value)

Represents stored data source of the external link.

function getDataSource() / function setDataSource(value)

Represents data source of the external link.

function isReferred()

Indicates whether this external link is referenced by others.

function isVisible()

Indicates whether this external link is visible in MS Excel.

function addExternalName(text, referTo)

Adds an external name.

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.