getCellHyperLink

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 2 revisions

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 );