Hyperlinks
xlide_manage_hyperlinkList, add, or remove hyperlinks on an Excel worksheet. Link cells to a URL, file path, or in-workbook location such as Summary!A1.
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 |
| offset | No | For list: links to skip. | |
| 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. | |
| max_results | No | For list: most links to return. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||