com.aspose.cells

com.aspose.cells

Class ExternalLink

  • java.lang.Object
    • 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("book1.xls");

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

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

Property Getters/Setters Summary
java.lang.StringgetDataSource()
void
setDataSource(java.lang.Stringvalue)
           Represents data source of the external link.
booleanisReferred()
Indicates whether this external link is referenced by others.
booleanisVisible()
Indicates whether this external link is visible in MS Excel.
java.lang.StringgetOriginalDataSource()
void
setOriginalDataSource(java.lang.Stringvalue)
           Represents stored data source of the external link.
intgetType()
Gets the type of external link. The value of the property is ExternalLinkType integer constant.
 
Method Summary
voidaddExternalName(java.lang.String text, java.lang.String referTo)
Adds an external name.
 

    • Property Getters/Setters Detail

      • getType

        public int getType()
        Gets the type of external link. The value of the property is ExternalLinkType integer constant.

      • getOriginalDataSource/setOriginalDataSource

        public java.lang.String getOriginalDataSource() / public void setOriginalDataSource(java.lang.String value)
        Represents stored data source of the external link.

      • 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 referenced by others.

      • isVisible

        public boolean isVisible()
        Indicates whether this external link is visible in MS Excel.

    setOriginalDataSource

    public voidsetOriginalDataSource(java.lang.Stringvalue)
    Represents stored data source of the external link.

    setDataSource

    public voidsetDataSource(java.lang.Stringvalue)
    Represents data source of the external link.

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