Skip navigation
ctongac
Currently Being Moderated

How to insert hyperlink into spreadsheet in CF9.0.1?

Mar 15, 2012 1:43 AM

Tags: #coldfusion9 #cfspreadsheet #cf9 #spreadsheetsetcellvalue

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

 
Replies
  • Currently Being Moderated
    Mar 22, 2012 7:05 AM   in reply to ctongac

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

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points