RE: [PHP-WIN] Closing Excel using DCOM and Release()

Ok thanks! That works fine for Word, but a similar techniques fails for Excel. I want to pull data from a spreadsheet - and have been trying to test out the technique using something like the code below. Thiw works fine, insofar that the data are correctly displayed on the browser, but Excel is still running afterwards. No error is give, but I need to be able to destroy the Excel object, or I will be quickly running out of resources! The code is ... <?php echo " <HTML><HEAD><TITLE>Processing Form</TITLE></HEAD><BODY BGCOLOR=\"#D5D5AB\"> <h1>This is a test</h1>"; $xlApp = new COM("Excel.Application") or Die ("Did not connect"); $workbook = "d:\wwwroot\studentdata\xl1.xls"; $wkb = $xlApp->Workbooks->Open($workbook) or Die ("Did not open"); $sheets = $wkb->Worksheets("Sheet1"); $cell = $sheets->Cells(1,1); print "Cell Value = {$cell->value} <BR>"; $xlApp->ActiveWorkbook->Close("False"); $xlApp->quit(); $xlApp = null; echo "</body></html>"; ?> -----Original Message----- From: Alain Samoun [mailto:alain@sonic.net] Sent: 10 September 2001 19:04 To: Jeff Waldock Cc: php-windows@lists.php.net Subject: Re: [PHP-WIN] Closing Excel using DCOM and Release() To close Word, you should use: $word->quit(); You are right, my PHPBuilder example has an error, thanks for pointing it to me ;) Alain On Mon, Sep 10, 2001 at 06:30:20PM +0100, Jeff Waldock wrote: > Thanks for the comment, but this code was lifted from an example on > PHPbuilder.com! The central problem is that the instance of Excel (or Word) > does not quit following $word->Quit(); I expected that the ->Release() > function would release the memory associated with the object, but it clearly > doesn't function because, as you say, it is not part of the Excel or Word > object model. In which case ... how do it destroy the object? > Jeff Waldock > > -----Original Message----- > From: Alain Samoun [mailto:alain@sonic.net] > Sent: 09 September 2001 21:55 > To: Jeff Waldock > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] Closing Excel using DCOM and Release() > > > As it said, your COM connection is closed, in addition 'release' is not a > member in the word object as well as in the excel object. > Alain > > On Sun, Sep 09, 2001 at 02:20:35PM +0100, Jeff Waldock wrote: > > I cannot seem to get PHP to recognise the Release function when tring to > > close an instance of Excel or Word opened using DCOM. > > > > This is the error message returned.. > > > > Warning: Unable to lookup release: The object invoked has disconnected > from > > its clients. in d:\wwwroot\studentdata\word.php on line 21 > > > > The code on line 21 is just > > $word->Release(); > > > > The full code is:: > > <?php > > > > // starting word > > $word = new COM("word.application") or die("Unable to instanciate Word"); > > print "Loaded Word, version {$word->Version}\n"; > > > > //bring it to front > > $word->Visible = 1; > > > > //open an empty document > > $word->Documents->Add(); > > > > //do some weird stuff > > $word->Selection->TypeText("This is a test..."); > > $word->Documents[1]->SaveAs("Useless test.doc"); > > > > //closing word > > $word->Quit(); > > > > //free the object > > $word->Release(); > > $word = null; > > > > ?> > > > > Where am I going wrong? > > > > Jeff Waldock > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net