com.aspose.cells.ExternalLink.html Maven / Gradle / Ivy
ExternalLink
com.aspose.cells
Class ExternalLink
java.lang.Object
com.aspose.cells.ExternalLink
public class ExternalLink
- extends java.lang.Object
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.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.
| 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.Cells Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.