[PHP] reading MS Excel?

2006-12-28 Thread William Stokes
Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] reading MS Excel?

2006-12-28 Thread Leonard Burton
On 12/28/06, Jiffy Slides Leonard Burton [EMAIL PROTECTED] 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

Re: [PHP] reading MS Excel?

2006-12-28 Thread Miles Thompson
At 09:49 AM 12/28/2006, William Stokes wrote: Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will Yes - but rather than re-invent the wheel, google for php read excel. Your solution may be there. Once you have read the information, then the rest is just an

Re: [PHP] reading MS Excel?

2006-12-28 Thread John Meyer
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

Re: [PHP] reading MS Excel?

2006-12-28 Thread Jiffy Slides Leonard Burton
HI John, My reply was made in ignorance of the php classes that will read excel documents. I would follow that road and not my advice! Leonard. On 12/28/06, John Meyer [EMAIL PROTECTED] wrote: On a side note, but going on the basis that the users are uploading .xls files and don't understand