Re: Closing Excel using DCOM and Release()

Well, to close your Excel App, you will use: xlApp->quit; Talk about consistency from M$ ;) For Excel, you may want to have a look at my class: http://www.phpbuilder.com/columns/alain20001003.php3 It's becoming old now, but still has some value I guess. Alain On Mon, Sep 10, 2001 at 07:25:30PM +0100, Jeff Waldock wrote: > 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