Getting rid of the Excel instance indeed is the tricky part of it:
With Excel 8 / PHP4.3.2 the problem lies in handling of the typelib(s):
// You might want to load the appropriate type library if you have to use
// excel constants on the interface. Do that by setting INI value
// com.autoregister_typelib = true
// As of PHP-4.3.2:
// ini_set('com.autoregister_typelib', true); does NOT work !!
// if you use register_typelib() you will get orphaned excel instances hanging around!
... but others had different experiences ...
HTH
--
Sven
> -----Ursprüngliche Nachricht-----
> Von: Jesper Palmqvist [Talarforum i Skandinavien AB] [SMTP:jesper.palmqvist@xxxxxxxxxxxxx]
> Gesendet am: Freitag, 21. Mai 2004 16:15
> An: php-windows@xxxxxxxxxxxxx
> Betreff: 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
