Page 1 of 1

Reading Excel spreadsheets from PHP

Posted: Wed Jul 06, 2005 3:21 pm
by raghavan20
I have come across this necessity to read an excel file and copy the contents into Mysql database. I was wondering, where can I find scripts or tutorials to read from a Excel file using PHP.

Posted: Wed Jul 06, 2005 3:26 pm
by Chris Corbyn
Saw this and thought of you ;)

http://www.hotscripts.com/Detailed/48157.html

EDIT | DOH! It costs $99.00 - I missed that bit :P

Posted: Wed Jul 06, 2005 3:34 pm
by wwwapu

Posted: Wed Mar 29, 2006 7:53 pm
by jonathant
Did you ever figure anything out with reading from excel files? I checked out the excel class mentioned previously and it looks like it only exports to excel. I'm a php newbie so maybe I'm misunderstanding it and it really does read from excel files. Anyways, if anyone knows how to read from an excel file that would be great. For my application I would like to read from excel and then write directly to mysql, or better yet, create a query string that could be run on mysql remotely. Any help would be greatly appreciated!

Posted: Wed Mar 29, 2006 8:07 pm
by feyd
ancient thread!

search pear.php.net, there's a proposed class that reads them.

Posted: Wed Mar 29, 2006 8:29 pm
by wtf
There's an excellent example in this book. You can download source files here and just go from there

http://www.oreilly.com/catalog/phphks/