Page 1 of 1

Excel to PHP array

Posted: Thu Jul 30, 2009 2:39 pm
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?

Re: Excel to PHP array

Posted: Fri Jul 31, 2009 1:09 am
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