How to insert hyperlink into spreadsheet in CF9.0.1?

[ctongac]

I was trying to insert a hyperlink into a cell of a spreadsheet like <a href="http://www.adobe.com">Go here</a> but there is no way to convert the cell value to hyperlink. It is not documented anywhere either. Please advise.

Thanks,

Chee

[-__cfSearching__- · Accepted solution]

It is not very obvious. You can create links using a formula and Excel's Hyperlink() function. Not tested, but something like this

     SpreadsheetSetCellFormula(sheet, 'HYPERLINK("http://www.adobe.com", "Go Here")', rowNumber, columnNumber);

[ctongac]

That works! However it does not appear in blue and underline but there is an easy fix with SpreadsheetFormatCell.

Thanks!