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
