NYCPHP Meetup

NYPHP.org

[nycphp-talk] de-moronizing an Excel sheet

David Mintz vtbludgeon at gmail.com
Mon Mar 5 15:05:34 EST 2007


I wanted to avoid the extra step of exporting to text, as in fact I've done
in the past. And I expect to have to repeat the procedure in the future.
But.... maybe that's the way to go after all.

Thanks for the suggestions!


On 3/5/07, Alvaro P. <apg88zx at gmail.com> wrote:
>
> Just be careful if you're exporting CSV's in a mac and using fgetcsv().
> You will need to set "auto_detect_line_endings = On" on the php.ini or
> the line breaks will be ignored.
>
> Alvaro
>
> Susan Shemin wrote:
> > I see there are fancy classes to handle this...
> >
> > But why not use the old-fashioned way and export your Excel data in a
> > CSV format and import it into MySQL?  I do it all the time with
> > locally inserting Office data into a MySQL database and creating
> > backups for my database.
> >
>
-- 
David Mintz
http://davidmintz.org/

En Nueva York el tránsito de la belleza a la desolación sucede siempre
expeditivamente, como si el principio universal de máxima eficiencia hubiera
aconsejado la supresión de gradaciones intermedias.

  -- Antonio Muñoz Molina, Ventanas de Manhattan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070305/6761a156/attachment.html>


More information about the talk mailing list