Hyperlinks
xlide_manage_hyperlinkManage hyperlinks in Excel worksheets: list, add, or remove links to URLs, files, or workbook locations. Specify target or internal location, optional display text.
Instructions
Lists, adds or removes hyperlinks on a worksheet. A link either goes out to a target, which is a URL or a file path, or inside the workbook to a location such as 'Summary!A1'. Pass one or the other. The cell's displayed text is separate from the link and is left alone unless you pass display.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | Worksheet name, matched without case. | |
| action | No | list, add or remove. | list |
| target | No | For add: a URL or file path to open. | |
| display | No | For add: text to put in the cell. | |
| tooltip | No | For add: the hover text. | |
| location | No | For add: a place in this workbook, like Summary!A1. | |
| file_path | Yes | Absolute path to the Excel file. | |
| cell_range | No | For add and remove: the cell or range. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||