Copy link to clipboard
Copied
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
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);
Copy link to clipboard
Copied
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);
Copy link to clipboard
Copied
That works! However it does not appear in blue and underline but there is an easy fix with SpreadsheetFormatCell.
Thanks!