EMAIL PROTECTED]
Subject: RE: [PHP] excel 2 csv 2 mysql
Pretty cool, man... I actually didn't know about xls2csv.
Learn something new every day -- this'll certainly come in handy.
'Course, it's not exactly standard with most distributions. For anyone
looking for it, you can dow
om: daniel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 1:26 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; daniel
Subject: RE: [PHP] excel 2 csv 2 mysql
ok i've built a class to acomplish this now
class Export_Excel {
var $command
function Export_Excel() {
The quotes are valid, use fgetcsv() function, it will strip them
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","sfafs
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
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(
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 lo
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"
http://www.ice.ru/~vitus/catdoc/ anyone seen this ? its pretty much wot i
needed, havent used it yet though
>= 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 op
on 01/04/03 11:48 AM, daniel ([EMAIL PROTECTED]) wrote:
> 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 :|
also see fgetscsv()
Justin
--
PH
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 t
10 matches
Mail list logo