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 Link to comment https://forums.phpfreaks.com/topic/215921-php-com-problem/ 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, Link to comment https://forums.phpfreaks.com/topic/215921-php-com-problem/#findComment-1122431 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, Link to comment https://forums.phpfreaks.com/topic/215921-php-com-problem/#findComment-1122470 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 ... Link to comment https://forums.phpfreaks.com/topic/215921-php-com-problem/#findComment-1122557 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.