com.aspose.cells

com.aspose.cells

Class ExternalLinkCollection

  • java.lang.Object
    • com.aspose.cells.ExternalLinkCollection
public class ExternalLinkCollection 
extends java.lang.Object

Represents external links collection in a workbook.

Example:

//Open a file with external links
Workbook workbook = new Workbook("d:\\book1.xls");

//Change external link data source
workbook.getWorksheets().getExternalLinks().get(0).setDataSource("d:\\link.xls");

Property Getters/Setters Summary
intgetCount()
Gets the number of elements actually contained in the collection.
ExternalLinkget(int index)
Gets the ExternalLink element at the specified index.
 
Method Summary
intadd(int directoryType, java.lang.String fileName, java.lang.String[] sheetNames)
Add an external link .
intadd(java.lang.String fileName, java.lang.String[] sheetNames)
Adds an external link.
 

    • Property Getters/Setters Detail

      • getCount

        public int getCount()
        Gets the number of elements actually contained in the collection.

      • get

        public ExternalLink get(int 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

        public int add(java.lang.String fileName, java.lang.String[] sheetNames)
        Adds an external link.
        Parameters:
        fileName - The external file name.
        sheetNames - All sheet names of the external file.
        Returns:
        The position of the external name in this list.

      • add

        public int add(int directoryType, java.lang.String fileName, java.lang.String[] sheetNames)
        Add an external link .
        Parameters:
        directoryType - A DirectoryType value. The directory type of the file name.
        fileName - the file name.
        sheetNames - All sheet names of the external file.
        Returns:
        The position of the external name in this list.