spreadsheetGetCellHyperlink

Returns a struct describing the hyperlink on a cell, such as its address and type.

spreadsheetGetCellHyperlink(spreadsheet, row, column) → returns struct

Argument Reference

spreadsheet any
Required

The spreadsheet object.

row numeric
Required

Row number (1-based).

column numeric
Required

Column number (1-based).

Compatibility

RustCFML:

Not supported on wasm32. Returns the hyperlink URL as a string, or an empty string if the cell has no hyperlink. Member form: getCellHyperlink(row, column).

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