How do you read data from an Excel spreadsheet using PHP?

I need to write some code that will open an excel spreadsheet and read the data stored in the spreadsheet. It's okay to know the type of data stored in the spreadsheet in advance, but not the specific data. I would like to be able to do this without saving the spreadsheet as a tab or comma delimited file first. I know that Microsoft uses a proprietary format to save its spreadsheets, but is there any way to read this format and reliably extract the data from it?

How do you read data from an Excel spreadsheet using PHP?
Yes, if you know the format. It's horrible and hard to get at.





Failing that you're going to need a library which you can hook into PHP. This will require some php hacking skills.





Or, you can try:


http://www.badblue.com/helpphpo.htm





Good luck.

love song lyrics