spreadsheetGetCellHyperlink

Returns the URL of the hyperlink attached to a cell in the active sheet of a spreadsheet workbook, or an empty string if the cell has no hyperlink. Rows and columns are 1-based. The fluent member form is getCellHyperlink(row, column).

spreadsheetGetCellHyperlink(spreadsheetObj, row, column) → returns string

This function requires RustCFML.  Not supported on Lucee, Adobe ColdFusion, etc.
  1. CFDocs
  2. Functions
  3. Spreadsheet Manipulation Functions
  4. spreadsheetGetCellHyperlink
  5. RustCFML
  6. 0 Issue
  7. Edit
See Also:   spreadsheetSetCellHyperlink   spreadsheetGetCellValue   spreadsheetNew

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

row numeric
Required

1-based row index of the cell.

column numeric
Required

1-based column index of the cell.

Compatibility

RustCFML:

Not supported on wasm32.

Examples
Sample code invoking the spreadsheetGetCellHyperlink function

Set a hyperlink on B2 and read its URL back.

wb = Spreadsheet("xlsx");
spreadsheetSetCellHyperlink(wb, "https://example.com", 2, 2, "Open link");
writeDump(spreadsheetGetCellHyperlink(wb, 2, 2));

Expected Result: https://example.com

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub