Example:
# Open a file with external links workbook = Workbook("ExternalFormula.xlsx") # Get External Link externalLink = workbook.getWorksheets().getExternalLinks().get(0) # Change External Link's Data Source externalLink.setDataSource("Book1.xlsx")
Property Getters/Setters Summary | ||
---|---|---|
method | getDataSource() | |
method | setDataSource(value) | |
Represents data source of the external link. | ||
method | isReferred() | |
Indicates whether this external link is referenced by others. | ||
method | isVisible() | |
Indicates whether this external link is visible in MS Excel. | ||
method | getOriginalDataSource() | |
method | setOriginalDataSource(value) | |
Represents stored data source of the external link. | ||
method | getType() | |
Gets the type of external link. The value of the property is ExternalLinkType integer constant. |
Method Summary | ||
---|---|---|
method | addExternalName(text, referTo) | |
Adds an external name. |
Property Getters/Setters Detail |
---|
getType : int | |
int getType() |
getOriginalDataSource/setOriginalDataSource : String | |
String getOriginalDataSource() / setOriginalDataSource(value) |
getDataSource/setDataSource : String | |
String getDataSource() / setDataSource(value) |
isReferred : boolean | |
boolean isReferred() |
isVisible : boolean | |
boolean isVisible() |
Method Detail |
---|
addExternalName | |
addExternalName(text, referTo) |
text: String
- The text of the external name.
If the external name belongs to a worksheet, the text should be as Sheet1!Text.
referTo: String
- The referTo of the external name. It must be a cell or the range.