How do I read the URL of a hyperlink within a cell using PHPExcel?
$url = $objPHPExcel->getActiveSheet()->getCell('E26')->getHyperlink()->getUrl();
EDIT
you might want to test whether the cell has a hyperlink first
$objPHPExcel->getActiveSheet()->getCell('E26')->hasHyperlink();
EDIT 2
Note that hyperlinks are not loaded when setReadDataOnly(true)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With