daniel wrote:
ok guys are you ready ,
/www_tools/apache/catdoc/bin/xls2csv test.xls > test2.csv
gave me this
"column1`","column2","column3" "faffafs","fsafsa","fsafs" "fssfa","fasfs","fasfs" "fasaf","fasfs","asffaf" "fafs","sfafsa","fasfas" "sfafs","fssfa","fassfa" "sfasfa","asfafs","fasfas" "asffas","sfaaf","sfafsa" "fssaf","asffsa","asffas" "sfasfa","sfasaf","fasasf"
unfortunately its putting quotes in, have to strip them
===== Original Message From <[EMAIL PROTECTED]> ===== Yeah... you're going to have to use COM or something similar on a windows server to get effective access to the server.
Another option is dynamically adding at as an odbc datasource and querying it. Again, this will only work on a windows server...
It's all much easier if you can convince users to upload csv files.
- jon
------------- jon roig senior manager, online production epilepsy foundation http://jonroig.com
-----Original Message----- From: daniel [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 7:48 PM To: [EMAIL PROTECTED] Subject: [PHP] excel 2 csv 2 mysql
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 :|
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php