SetHyperlink
Adds a hyperlink to the specified range.
Syntax
expression.SetHyperlink(sRange, sAddress, subAddress, sScreenTip, sTextToDisplay);
expression - A variable that represents a ApiWorksheet class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| sRange | Required | string | The range where the hyperlink will be added to. | |
| sAddress | Required | string | The link address. | |
| subAddress | Optional | string | The link subaddress to insert internal sheet hyperlinks. | |
| sScreenTip | Optional | string | The screen tip text. | |
| sTextToDisplay | Optional | string | The link text that will be displayed on the sheet. |
Returns
boolean
Example
Attach a clickable hyperlink to a cell range in a spreadsheet.
// How do I add a hyperlink to a cell in a spreadsheet?
// Link a cell to an external URL so users can navigate to it directly in a spreadsheet.
let worksheet = Api.GetActiveSheet();
const logoUrl = 'https://static.onlyoffice.com/assets/docs/samples/img/onlyoffice_logo.png';
worksheet.SetHyperlink('A1', logoUrl, null, 'ONLYOFFICE for developers', 'Api ONLYOFFICE');