Get hyperlink information.(Microsoft Excel Office Scripts)

04/07/2023

Japanese version.

Introduction to how to get cell hyperlink (on the Web, in documents) information via Office scripts.

Operations

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.

Property	Description
address	URL of the web link.
documentReference	Linked cell address for links in documents.
screenTip	Callout (tooltip) on mouseover.
textToDisplay	Cell Value.

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.

Links

Office Scripts Articles

Office Scripts(Microsoft Excel)