SV: [PHP-WIN] 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@t-online.de] Skickat: den 21 maj 2004 14:14 Till: '[PHP-WIN]' Ämne: AW: [PHP-WIN] 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@ingenta.com] > Gesendet am: Freitag, 21. Mai 2004 12:08 > An: php-windows@lists.php.net > Betreff: [PHP-WIN] 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