Excel to PHP array

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
allspiritseve
DevNet Resident
Posts: 1174
Joined: Thu Mar 06, 2008 8:23 am
Location: Ann Arbor, MI (USA)

Excel to PHP array

Post by allspiritseve »

Ugh. I've been messing around with PHPExcel trying to figure out how to turn a client's excel file into a php array to store in MySQL. Their documentation seems extensive but doesn't have much on reading files-- it seems centered around writing them. All I want to do is get B3-I22 from the file as an array. It seems to me this should be really easy, as in, not needing a 5MB library to do it. Any suggestions?
joeynovak
Forum Commoner
Posts: 26
Joined: Sun May 10, 2009 11:09 am

Re: Excel to PHP array

Post by joeynovak »

It would seem it should be easy doesn't it. Unfortunatly it's some proprietary, overly complicated format whose structure is more closely related to a FAT filesystem then an array (from what I read a long time ago).

Try:
they did all the hard work and you should be able to read it. If that failes, save it as a csv file, and use php to parse the csv file.

Happy Coding,

Joey
Post Reply