NYCPHP Meetup

[Susan Shemin]

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.


----- Original Message ----
From: David Mintz <vtbludgeon at gmail.com>
To: talk at lists.nyphp.org
Sent: Monday, March 5, 2007 2:04:22 PM
Subject: [nycphp-talk] de-moronizing an Excel sheet

Hey everyone,

Is anyone familiar with this Spreadsheet_Excel_Reader class? http://sourceforge.net/project/showfiles.php?group_id=99160

I need to import Excel to MySQL. This class seems promising -- I have started playing and can get the data into PHP, no problem. Except that the single quotes, double quotes, em dashes, et cetera are wreaking havoc. Does anyone know of any solution? I see there are setOutputEncoding() and setUTFEncoder() methods but I am not sure whether they are what I need and what values to pass them.

Thanks.

-- 
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
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070305/7b92e2d6/attachment.html>