开发者

extracting link from php excel reader

开发者 https://www.devze.com 2023-02-28 18:46 出处:网络
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

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?

0

精彩评论

暂无评论...
验证码 换一张
取 消