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:[EMAIL PROTECTED]]
> Sent: 10 September 2001 19:04
> To: Jeff Waldock
> Cc: [EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]]
> > Sent: 09 September 2001 21:55
> > To: Jeff Waldock
> > Cc: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
