php excel, how to set clickable url

$this->phpExcelObj->getActiveSheet()->setCellValueExplicit('‌​A1', $id, PHPExcel_Cell_DataType::TYPE_STRING2, TRUE)->getHyperlink()->setUrl(strip_tags($link));

A1 is the position of cell
$id is the text value

$link is the url 

  • 2 Users Found This Useful
這篇文章有幫助嗎？

相關文章

database commands

from https://codeigniter.com/userguide2/database/active_record.html...

For online form capture multimedia on mobile devices

<p>Capture Image: <input type="file" accept="image/*" id="capture" capture="camera">...

how to get value from database

https://stackoverflow.com/questions/8541291/codeigniter-this-db-get-how-do-i-return-values-for-a-...

add button to perform function

https://www.w3schools.com/jsref/tryit.asp?filename=tryjsref_onclick <!DOCTYPE...