When creating excel files using PHPExcel, on setting a hyperlink the cell value’s styling is generally not affected. This happens on purpose to give us more control on how we want to format our content. Usually this is how we’d set a hyperlink:
// Set hyperlink
$objPHPExcel->setActiveSheetIndex(0)
->getCell("A1")
->getHyperlink()
->setUrl('http://google.com');
// Set cell content
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue("A1", 'http://google.com/'); // Could also set to lets say "Google"
On viewing the excel file, the link won’t appear to be blue with an underline – which is what we’d expect to happen inherently. In order to achieve that, we’ll need to style/format it accordingly:
What's the one thing every developer wants? More screens! Enhance your coding experience with an external monitor to increase screen real estate.
// Config
$link_style_array = [
'font' => [
'color' => ['rgb' => '0000FF'],
'underline' => 'single'
]
];
// Set it!
$objPHPExcel->getActiveSheet()->getStyle("A1")->applyFromArray($link_style_array);
Various values supported by the underline option are none, single, singleAccounting, double and doubleAccounting.
Hope that helps!
Recommended for you: Get network issues from WhatsUp Gold. Not end users.
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download
