You might try putting a "UserControl = False" in there. The application should automatically end when it's called from COM (unless "UserControl = True") is set. But you could also try making sure to explicity "Quit()" the the application too. If you interrupted the script in the middle of running, it might leave the application running if UserControl is TRUE or it for some reason assumes that it's TRUE (something wrong with the "COM call = UserControl = FALSE" mechanism or something). Just some thoughts. -TG > -----Original Message----- > From: Jesper Palmqvist [Talarforum i Skandinavien AB] > [mailto:jesper.palmqvist@xxxxxxxxxxxxx] > Sent: Friday, May 21, 2004 10:15 AM > To: php-windows@xxxxxxxxxxxxx > Subject: SV: updating from xls -> [filter] -> mysql > > > I have been using PHP with COM > > On my Win2000 platform running PHP as a module on Apache2 the excel > application doesn't end after the script ends > > The script ends: > > $exapp->Quit(); > unset($exapp); > ?> > > What could be the problem? > > /Jesper > > > -----Ursprungligt meddelande----- > Från: Sven Schnitzke [mailto:Sven.Schnitzke@xxxxxxxxxxx] > Skickat: den 21 maj 2004 14:14 > Till: '' > Ämne: AW: updating from xls -> [filter] -> mysql > > > Hi George, > are you familiar with COM? If so, consider: > > // select range to $r , then do > if($r->NumberFormat()="a format") { ... } > > where "a format" can be "Standard" or something like > "#,##0.00; -###0.00" or so as used in the "Format - Cells" dialog of > Excel. > > With Excel 8 there seems to be a glitch as it returns localized colour > names and does not accept english ones (At least my German version > behaves this way; didn't scrutinize too deeply though). > > If you are interested I will send you a basic PHP COM script > doing EXCEL > I/O to start from. > > HTH > -- > Sven Schnitzke > > > > -----Ursprüngliche Nachricht----- > > Von: George Pitcher [SMTP:george.pitcher@xxxxxxxxxxx] > > Gesendet am: Freitag, 21. Mai 2004 12:08 > > An: php-windows@xxxxxxxxxxxxx > > Betreff: updating from xls -> [filter] -> mysql > > > > Hi, > > > > I'm thinking ahead to something I'll need to tackle in the future. > > > > My current system is Filemaker based and I can import straight from > > Excel spreadsheets - but with no checking available. Now that I'm > > re-writing into php/mysql(pear:dB)/smarty, If I can, I'd > like the user > > > to be able to select the file (I can do that bit), check that the > > column positions match a predefined format (?), and then update > > records in my db table. > > > > Does this look doable? Any hints on how? I don't want to > use ODBC as > > the filename will be constantly changing so there'll be no > dsn set up. > > > > George in Oxford > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
