how can we read excel file using php?

[An156]

Hi All,
how can we read excel file using php?

plz help!

[webfoo]

If you have the database drivers on your server set up to read from the Excel as a database, then you can query it using SQL.

You might instead try saving it as a .csv and then
fopen("yourfile.csv);
That might not work, I haven't tried it. Hope this helps.

[NeilsPHP]

An156,
I came across this link while searching similar solution:
[ibm.com...]

It works very easily as far as importing the data and displaying on webpage but I can not get the part where we can store the data from excel into mysql.
I was able to install pear db package but stumbled on DSN syntax & ODBC interfacing etc.may be somebody can help us hereonwards ?