JavaScript is disabled on your browser.
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("d:\\link.xls");
Property Getters/Setters Summary
java.lang.String
getDataSource ()
void
setDataSource (java.lang.String)
Represents data source of the external link.
boolean
isReferred ()
Indicates whether this external link is referenced by others.
boolean
isVisible ()
Indicates whether this external link is visible in MS Excel.
java.lang.String
getOriginalDataSource ()
void
setOriginalDataSource (java.lang.String)
Represents stored data source of the external link.
int
getType ()
Gets the type of external link.
The value of the property is ExternalLinkType integer constant.
Method Summary
void
addExternalName (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.
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.Cells Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.