aspose.cells
Class ExternalLinkCollection

//Open a file with external links
$workbook = new cells\Workbook("Book1.xls");
//Change external link data source
$workbook->getWorksheets()->getExternalLinks()->get(0)->setDataSource("Book2.xls");

function getCount()

Gets the number of elements actually contained in the collection.

function get(index)

Gets the ExternalLink element at the specified index.

Parameters:

index - The zero based index of the element.

Returns:

The element at the specified index.

function add(fileName, sheetNames)

Adds an external link.

Parameters:

fileName: String - The external file name.

sheetNames: String[] - All sheet names of the external file.

Returns:

The position of the external name in this list.

function add(directoryType, fileName, sheetNames)

Add an external link .

Parameters:

directoryType: Number - A DirectoryType value. The directory type of the file name.

fileName: String - the file name.

sheetNames: String[] - All sheet names of the external file.

Returns:

The position of the external name in this list.