...
Excerpt |
---|
Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks. |
Creating a hyperlink to another cell or range within the workbook is not supported. However, you may use a hyperlink formula to achieve the same functionality. For example, to link to cell C3 you would use the formula =HYPERLINK("#Sheet1!C3", "Link to C3")
. Setting Cell.Formula with this formula will create the internal hyperlink.
Signature |
---|
|
public Hyperlink CreateHyperlink(Area area, System.String href)
|
...
Returns |
---|
A new Hyperlink object with the specified destination URL. |
Remarks |
---|
Creating a hyperlink to another cell or range within the workbook is not supported. However, you may use a hyperlink formula to achieve the same functionality. For example, to link to cell C3 you would use the formula =HYPERLINK("#Sheet1!C3", "Link to C3") . Setting Cell.Formula with this formula will create the internal hyperlink. |
Example |
---|
Code Block |
---|
|
links.CreateHyperlink(a, "http://www.softartisans.com"); |
Code Block |
---|
|
links.CreateHyperlink(a, "http://www.softartisans.com") |
|