aspose.cells

Class ExternalLinkCollection

Represents external links collection in a workbook.

Example:

//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");

Property Getters/Setters Summary
functiongetCount()
Gets the number of elements actually contained in the collection.
functionget(index)
Gets the ExternalLink element at the specified index.
 
Method Summary
functionadd(directoryType, fileName, sheetNames)
Add an external link .
functionadd(fileName, sheetNames)
Adds an external link.
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()
        
        Gets the number of elements actually contained in the collection.
      • get : ExternalLink 

        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.
    • Method Detail

      • add

        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.
      • add

        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.