Importing data from Excel into PHP

[Michal Maciejczak]

Is it possible to import data from excel file into php and than put it in
mysql database?

[charliefortune]

my brother imports excel sheets straight into mysql - would that be of
use to you ?

[Michal Maciejczak]

I ment only data from excel sheets, from fields A1,A2,B1,B2 etc. then I
could sort this data out and put them nicely into mysgl database

my brother imports excel sheets straight into mysql - would that be of
use to you ?

[Justin Koivisto]

Michal Maciejczak wrote:

I ment only data from excel sheets, from fields A1,A2,B1,B2 etc. then I
could sort this data out and put them nicely into mysgl database

sounds like a job for the COM functions:

http://us3.php.net/manual/en/ref.com.php

--
Justin Koivisto, ZCE - ju****@koivi.com
http://koivi.com

[Frank [GOD]]

Save the data you want imported as CSV... then use mysqlimport from the
command line or in your PHP code!!
Another problem solved by GOD...

Frank
Michal Maciejczak wrote:

Is it possible to import data from excel file into php and than put it in
mysql database?

[G0ng]

Frank [GOD] wrote:

Save the data you want imported as CSV... then use mysqlimport from the
command line or in your PHP code!!
Another problem solved by GOD...

Frank

I'm using this in my website with no problem. I think it's the best (or
only?) solution cause you can also manipulate the data....

e.g $fp is the csv file

$tmp=fgets($fp);
while(!feof($fp)) {
$tmp=fgets($fp);
$t=explode(";",$tmp);
$val=str_replace("\"","",$t);
$val=str_replace("\\","",$val);

insert into....

[Geoff Muldoon]

mi***************@tesco.net says...

Is it possible to import data from excel file into php and than put it in
mysql database?

Check out:
http://sourceforge.net/projects/phpexcelreader/
and
http://paggard.com/projects/xls.reader/

Geoff M

[Michal Maciejczak]

Thank you very much,
That's exacly what I've been looking for