Re:excel 2 csv 2 mysql
| From: | Geoff Caplan | Date: | Tue, 01 Apr 2003 11:51:49 +0000 |
| Subject: | Re:excel 2 csv 2 mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-141808@lists.php.net to get a copy of this message | ||
Justin,
For reading, you could try this:
http://www.zakkis.ca/products/abc_excelparser/index.php
Cost is 150 CAD - quite steep. Tried the online demo - seems to work. Will only work
with cells containing strings though - doesn't resolve formulae. If
you purchase it, perhaps you could let me know how you get on?
For writing, there seems to be a module in Pear:
http://pear.php.net/package-info.php?pacid=156
>> hi guys i am trying to work out how to dynamically be able to upload an excel
>> file , export it to csv to be able to import into mysql , is there any
>> examples out there ? fopen gave me binary code :|
--
Geoff Caplan
Advantae Ltd
http://www.advantae.com