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.
Advice on a PHP XLS parser
Moderator: General Moderators
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
see also:
http://msdn2.microsoft.com/en-us/library/aa218785.aspx
http://www.microsoft.com/downloads/deta ... laylang=en