Read Hyperlink URL

How to read a hyperlink url inside a cell using PHPExcel?

+5
source share
1 answer
$url = $objPHPExcel->getActiveSheet()->getCell('E26')->getHyperlink()->getUrl();

EDIT

you can check if the cell has the first hyperlink

$objPHPExcel->getActiveSheet()->getCell('E26')->hasHyperlink();

EDIT 2

Note that hyperlinks do not load when setReadDataOnly (true)

+16
source

All Articles