Introduction to how to get cell hyperlink (on the Web, in documents) information via Office scripts.
The following syntax is used (Red text indicates variable parts)
// Get hyperlink information let variable = workbook.getWorksheet("sheet").getRange("cell address").getHyperlink(); Obtain hyperlink information console.log(variable.address); // URL of the web link console.log(variable.documentReference); // Linked cell address for links in documents console.log(variable.screenTip); // Callout (tooltip) on mouseover console.log(variable.textToDisplay); // Cell Value
Information is used in the following properties.
Items that are not set will be null.
|address||URL of the web link.|
|documentReference||Linked cell address for links in documents.|
|screenTip||Callout (tooltip) on mouseover.|
For those who want to learn Office script effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.