[thelist] importing .xls files in MySQL

Jon Molesa rjmolesa at consoltec.net
Thu Jul 24 19:45:11 CDT 2008

On a linux system I've used xls2csv in an exec call.  xls2csv is
provided by catdoc on a debian based system.  Then I just used fgetcsv
to read that file.  If data is what you're after it'll work.  However,
the moment you need to read functions, cell references, etc. if breaks.

*On Thu, Jul 24, 2008 at 02:41:20PM -0500 Jeremy Weiss <eccentric.one at gmail.com> wrote:

> Date: Thu, 24 Jul 2008 14:41:20 -0500
> From: Jeremy Weiss <eccentric.one at gmail.com>
> Subject: [thelist] importing .xls files in MySQL
> To: Evolt <thelist at lists.evolt.org>
> I've got a client that's wanting to be able to upload .xls files and have a
> PHP script parse the file and insert it's content into a MySQL database.
> Having her convert the files to another format isn't an option. I've done a
> bit of googling but wasn't able to uncover anything really helpful.
> Could someone point me in the right direction (maybe a class that you've
> used in the past or something)?
> Thanks,
> -jeremy
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious

More information about the thelist mailing list