Example:
# Instantiating a Workbook object
workbook = Workbook()
# Adding a new worksheet to the Workbook object
workbook.getWorksheets().add()
# Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.getWorksheets().get(0)
# Adding a hyperlink to a URL at "A1" cell
worksheet.getHyperlinks().add("A1", 1, 1, "http://www.aspose.com")
# Saving the Excel file
workbook.save("Book1.xls")
| Property Getters/Setters Summary | ||
|---|---|---|
method | getAddress() | |
method | setAddress(value) | |
| Represents the address of a hyperlink. | ||
method | getArea() | |
Gets the range of hyperlink.
|
||
method | getLinkType() | |
Gets the link type.
The value of the property is TargetModeType integer constant. |
||
method | getScreenTip() | |
method | setScreenTip(value) | |
| Returns or sets the ScreenTip text for the specified hyperlink. | ||
method | getTextToDisplay() | |
method | setTextToDisplay(value) | |
| Represents the text to be displayed for the specified hyperlink. The default value is the address of the hyperlink. | ||
| Method Summary | ||
|---|---|---|
method | delete() | |
Deletes this hyperlink
|
||
String getAddress() / setAddress(value)
String getTextToDisplay() / setTextToDisplay(value)
String getScreenTip() / setScreenTip(value)
int getLinkType()