Page 1 of 1

Advice on a PHP XLS parser

Posted: Fri Jul 20, 2007 6:02 am
by impulse()
I've came across a few of these today, none which seem to give expected output though.

The best by far is XLS Reader Class 1.2 http://paggard.com/projects/xls.reader/ which gives exactly what I want, but unfortunately it's 69USD.

Another one that keep cropping up on Google is PHP-ExcelReader http://sourceforge.net/project/download ... or=surfnet but this gives lots of jibberish output and doesn't seem to put XLS columns into array elements.

Has anybody here used a free XLS parser that worked as expected?


The reason for needed this is I'm saving Microsoft Outlook messages as Excel files and then I'm hoping to parse them in PHP so I can insert them into a MySQL database. I've tried exporting from Outlook as CSV but because some of the field contain quotation marks within the cells it's causing the CSV feature in phpMyAdmin to not understand the file correctly.

Posted: Fri Jul 20, 2007 8:19 am
by volka
Might be easier to use VBA to write the data to an odbc/mysql database.
see also:
http://msdn2.microsoft.com/en-us/library/aa218785.aspx
http://www.microsoft.com/downloads/deta ... laylang=en

Posted: Fri Jul 20, 2007 12:10 pm
by impulse()
The problem is sorted now. I wasn't checking through the whole array. The data was there, I was just wasn't patient enough to look through it all.

Oops :)