Advice on a PHP XLS parser
Posted: Fri Jul 20, 2007 6:02 am
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.
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.