getCellHyperLink - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns the target/URL of a hyperlinked cell, or an empty string if the cell does not contain a hyperlink.

getCellHyperLink( workbook, row, column )

Required arguments

• workbook spreadsheet object
• row numeric
• column numeric

Chainable? Yes but ends the chain.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.setCellHyperLink( workbook, "https://github.com/", 1, 1 );
theUrl = spreadsheet.getCellHyperLink( workbook, 1, 1 );