Get Hyperlink

Retrieves hyperlink information from a specific cell, including the link address and display text.

Common Properties

• Name - The custom name of the node.
• Color - The custom color of the node.
• Delay Before (sec) - Waits in seconds before executing the node.
• Delay After (sec) - Waits in seconds after executing the node.
• Continue On Error - Automation will continue regardless of any error. The default value is false.

info

If ContinueOnError property is true, no error is caught when the project is executed even if the Catch node is used.

Input

• File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
• Cell - Cell address containing the hyperlink (e.g., A1, B5, C10).

Output

• Result - Object containing hyperlink information with the following properties:
  • Text - The display text of the cell
  • Address - The external URL or file path (empty if no external link)
  • SubAddress - The internal Excel reference like a cell or range (empty if no internal link)
  • HasHyperlink - Boolean indicating whether the cell contains a hyperlink

Options

This node has no additional options.

Example

Getting a web URL hyperlink:

// File Descriptor: message.excel_fd
// Cell: "A1"
// Output: {
//   Text: "Visit our website",
//   Address: "http://example.com",
//   SubAddress: "",
//   HasHyperlink: true
// }

Getting an internal sheet reference:

// Cell: "B5"
// Output: {
//   Text: "Go to Summary",
//   Address: "",
//   SubAddress: "Summary!A1",
//   HasHyperlink: true
// }

Getting a cell without a hyperlink:

// Cell: "C10"
// Output: {
//   Text: "Regular text",
//   Address: "",
//   SubAddress: "",
//   HasHyperlink: false
// }

Checking and using hyperlink data:

// After Get Hyperlink:
// if (message.hyperlink.HasHyperlink) {
//   let url = message.hyperlink.Address;
//   // Use the URL for web scraping or validation
// }

Tips

• Address contains external URLs (http://, https://) or file paths.
• SubAddress contains internal Excel references (e.g., "Sheet2!A1").
• A hyperlink can have both Address and SubAddress (link to a file with a specific location).
• HasHyperlink is true even if the cell has only formatting that looks like a link.
• Use this to extract and validate links before processing them.

Common Errors

Error	Solution
Cell cannot be empty	Provide a valid cell address (e.g., A1, B5)
Invalid File Descriptor	Ensure the Open Excel node was executed first
Invalid cell address	Use proper Excel cell notation (column letter + row number)