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 <[EMAIL PROTECTED]>
To: [email protected]
Sent: Monday, March 5, 2007 2:04:22 PM
Subject: [nyphp-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
_______________________________________________
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
