Re: reading MS Excel?
| From: | John Meyer | Date: | Thu, 28 Dec 2006 22:54:02 +0000 |
| Subject: | Re: reading MS Excel? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-246261@lists.php.net to get a copy of this message | ||
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@jiffyslides.com> 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@gmail.com
>>
>> "The prolonged evacuation would have dramatically affected the
>> survivability of the occupants."
>>
>
>