Hyperlinks are not opening from Microsoft Excel (PHPExcel)

Topics: Developer Forum, User Forum
Dec 5, 2012 at 2:44 PM
Edited Dec 5, 2012 at 2:45 PM

I am using the following code to generate hyperlinks in excel


$objPHPExcel->getActiveSheet()->getCell($column_index . $row_index)->getHyperlink()->setUrl( 'http://www.c4online.me/c4v2/index.php?q=file');


The link opens when the file is opened using "LibreOffice Calc" on ubuntu and using "Numbers" on Mac. But when it comes to Microsoft Excel 2007 and 2010 I get the following warning:


the internet site reports that the item you requested could not be found ( HTTp/1.0 404)

Can you please tell me when did I go wrong?

Dec 6, 2012 at 7:36 AM

I don't know what you're doing wrong, other than that site gives a 404 response in a browser.

Excel doesn't care what the link is, because it simply triggers the default web browser to open the link, so it's the browser that actually sends the request. What browser is the link opening up in? Can you see the correct address in the address bar? 

Dec 9, 2012 at 5:20 AM

the browser is Chrome, and the address opens in the address bar. Yet i noticed something:

The link gives the warding when i set the link for example http://mydomain.com/subdomain/SOME_GET_PARAMS

But it works if i remove the sub-domain for example http://mydomain.com/SOME_GET_PARAMS


So this is where i am stuck right now