asposecells.api

Class ExternalLinkCollection

Represents external links collection in a workbook.

Example:

# Open a file with external links
workbook = Workbook("ExternalFormula.xlsx")
# Change external link data source
workbook.getWorksheets().getExternalLinks().get(0).setDataSource("Book2.xlsx")

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

    • Property Getters/Setters Detail

      • getCount : int 

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

        ExternalLink 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

        int 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

        int add(directoryType, fileName, sheetNames)
        Add an external link .
        Parameters:
        directoryType: int - 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.