com.aspose.cells
Class ExternalLink

java.lang.Object
    extended by com.aspose.cells.ExternalLink

public class ExternalLink 
extends java.lang.Object

Represents an external link in a workbook.

Example:

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

//Get External Link 
ExternalLink externalLink = workbook.getWorksheets().getExternalLinks().get(0);

//Change External Link's Data Source
externalLink.setDataSource("d:\\link.xls");

Property Getters/Setters Summary
java.lang.StringgetDataSource()
voidsetDataSource(java.lang.String value)
           Represents data source of the external link.
booleanisReferred()
           Indicates whether this external link is refered by others.
 
Method Summary
voidaddExternalName(java.lang.String text, java.lang.String referTo)
           Adds an external name.
 

Property Getters/Setters Detail

getDataSource/setDataSource

public java.lang.String getDataSource() / public void setDataSource(java.lang.String value)
Represents data source of the external link.

isReferred

public boolean isReferred()
Indicates whether this external link is refered by others.

Method Detail

addExternalName

public void addExternalName(java.lang.String text, java.lang.String referTo)
Adds an external name.
Parameters:
text - The text of the external name. If the external name belongs to a worksheet, the text should be as Sheet1!Text.
referTo - The referTo of the external name. It must be a cell or the range.

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