Data type url link

Topics: Developer Forum, Project Management Forum, User Forum
Sep 7, 2012 at 12:59 PM
Edited Sep 7, 2012 at 1:01 PM

Hi,

i've a problem with the phpexcel library..

When i generate my export excel with this code:

$sheet->setCellValueByColumnAndRow($col76, $rowIterator76, html_entity_decode($string,ENT_QUOTES,'UTF-8'));
$sheet->getCellByColumnAndRow($col76, $rowIterator76)->getHyperlink()->setUrl('http://myurl...');

i can't see the hyperlink style (underline blue link).

what can i do?

 

thanks in advance

 

Coordinator
Sep 7, 2012 at 7:03 PM

All setting a hyperlink does in PHPExcel is set a hyperlink, it does not affect any cell styling... that's up to you. This is not a bug, it's a deliberate principle to give you control over how your spreadsheet appears.