php - Reading hyperlink URL -


how read url of hyperlink within cell using phpexcel?

$url = $objphpexcel->getactivesheet()->getcell('e26')->gethyperlink()->geturl(); 

edit

you might want test whether cell has hyperlink first

$objphpexcel->getactivesheet()->getcell('e26')->hashyperlink(); 

edit 2

note hyperlinks not loaded when setreaddataonly(true)


Comments