spreadsheetSetCellHyperlink

Adds a hyperlink to a cell.

spreadsheetSetCellHyperlink(spreadsheet, hyperlink) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

Compatibility

RustCFML:

Not supported on wasm32. Uses a different signature: spreadsheetSetCellHyperlink(spreadsheetObj, link, row, column [, tooltip]). An empty cell shows the link as its text. Member form: setCellHyperlink(link, row, column, tooltip).

Examples
Sample code invoking the spreadsheetSetCellHyperlink function

Link B2 to example.com with a tooltip.

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

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

Fork me on GitHub