I have an excel sheet with google as one of the data cells and it is a hyperlin开发者_JAVA百科k to say http://www.google.com
Can this link be extracted using php excel reader?
Thank you in advance.
To read the URL for a hyperlink in cell A1 in the current active worksheet, it's as easy as:
$url = $objPHPExcel->getActiveSheet()->getCell('A1')->getHyperlink()->getUrl();
if you're using PHPExcel
Otherwise, which PHP Excel Reader are you actually using?
精彩评论