abdfahim Posted October 15, 2010 Share Posted October 15, 2010 Hi, I am trying to write in an existing excel file. But for some reason, I can't open the workbook (but I know I have made similar code work before). Here I am just pasting the code upto the error line $filename="C:\\apache\\htdocs\\GAC2\\dload\\template.xls"; $excel = new COM("excel.application") or die("Unable to instanciate excel"); $excel->Visible = 1; $excel->DisplayAlerts = 1; try{ $wkb = $excel->Workbooks->Open($filename); }catch (Exception $e) { echo 'Caught exception: ', $e->getMessage(), "\n"; } //........ Later part of the code This returns the following error Caught exception: Source: Microsoft Office Excel Description: Unable to get the Open property of the Workbooks class For record, the I have already validated the file location. And I have tried the following line instead without any positive result. $filename="C:\apache\htdocs\GAC2\dload\template.xls"; Looking for any help please. -Abd Quote Link to comment Share on other sites More sharing options...
chintansshah Posted October 15, 2010 Share Posted October 15, 2010 use $filename = "C:/apache/htdocs/GAC2/dload/template.xls"; I am not 100% sure, Quote Link to comment Share on other sites More sharing options...
abdfahim Posted October 15, 2010 Author Share Posted October 15, 2010 use $filename = "C:/apache/htdocs/GAC2/dload/template.xls"; I am not 100% sure, Nope, this is not the case .. Thanks anyway, Quote Link to comment Share on other sites More sharing options...
abdfahim Posted October 15, 2010 Author Share Posted October 15, 2010 hello experts, looking for any solution please ... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.