Excel to PHP array
Moderator: General Moderators
- allspiritseve
- DevNet Resident
- Posts: 1174
- Joined: Thu Mar 06, 2008 8:23 am
- Location: Ann Arbor, MI (USA)
Excel to PHP array
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
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:
Happy Coding,
Joey
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