com.aspose.cells
Class ExternalLinkCollection

java.lang.Object
    extended by 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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.