Re: [PHP] reading MS Excel?

On a side note, but going on the basis that the users are uploading .xls
files and don't understand how to convert. Would it be better to use
php's routines or to automate excel, convert it inside there, and then
use the result?
Leonard Burton wrote:
On 12/28/06, Jiffy Slides Leonard Burton <service@xxxxxxxxxxxxxxx> wrote:
HI Will,

Is it possible to read Excel files and store the info to DB? If so how?

It is best (well depending on the application) to save the files as
.csv and then use fgetcsv. it will allow you to parse each line and
cell in the file and then go from there.

Take Care,

--
Leonard Burton, N9URK
leonardburton@xxxxxxxxx

"The prolonged evacuation would have dramatically affected the
survivability of the occupants."



.