ok i've built a class to acomplish this now
class Export_Excel {
var $command
function Export_Excel() {
$this->command = "/www_tools/apache/catdoc/bin/xls2csv";
}
function xls2csv($path,$xls_file,$short_name) {
$cmd = escapeshellcmd("$this->command -q 0 $path.$xls_file");
$cmd .= " > $path.$short_name.csv";
@exec($cmd,$stdout,$errocode);
unlink("$path.$xls_file");
if ($errorcode > 0) return $errocode;
}
}
and here is my db class function
function
insert_file($filename,$table,$col_terminator,$line_terminator,$cols=false,$opt
ions=false,$remove_file=false) {
if ($options) $option = "OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED
BY
'\n'";
$this->query("LOAD DATA INFILE '$filename' INTO TABLE $table FIELDS
TERMINATED BY '$col_terminator' $option $cols");
if ($remove_files) unlink($filename);
}
its just a quicky, twiddling thumbs today i just had to find out how to do it
:D
>===== Original Message From daniel <[EMAIL PROTECTED]> =====
>ok it works now
>
>/www_tools/apache/catdoc/bin/xls2csv -q 0 test.xls > test2.csv
>
>
>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
>
>then i can load that into mysql using load data into :D, aparantly there are
>some bugs , gotta find them
>>===== Original Message From daniel <[EMAIL PROTECTED]> =====
>>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
>
>
>
>--
>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
