.
| Description |
|---|
| Excerpt |
|---|
Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks. |
| Signature | C# | C# |
|---|---|---|
| Wiki Markup | ||
{description}
{excerpt}Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks.{excerpt}
{signature:C#}
public Hyperlink CreateHyperlink(Area area, System.String href)
| ||
| Signature | ||
{signature}{signature:vb.net | vb.net | }
Public Function CreateHyperlink(ByVal area As Area, ByVal href As String) As Hyperlink
|
| Parameters |
|---|
...
An Area object representing the cells that will be converted to hyperlinks.
...
The hyperlink's destination.
| 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 {signature} {parameters} {param:area}An [Area|Area] object representing the cells that will be converted to hyperlinks.{param} {param:href}The hyperlink's destination.{param} {returns}A new [Hyperlink|Hyperlink] object with the specified destination URL.{returns} {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 | | csharp | csharp |
| title | C# | ||
| Code Block | vb.net | title |