Advice on a PHP XLS parser

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

Advice on a PHP XLS parser

Post 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.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

Post 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 :)
Post Reply