[thelist] importing .xls files in MySQL

[Jon Molesa]

One more thing.  xls2csv will only grabe the contents of one sheet.

You might also want to check out phpclasses.org if you need something
more capable.

*On Thu, Jul 24, 2008 at 08:45:11PM -0400 Jon Molesa <rjmolesa at consoltec.net> wrote:

> Date: Thu, 24 Jul 2008 20:45:11 -0400
> From: Jon Molesa <rjmolesa at consoltec.net>
> Subject: Re: [thelist] importing .xls files in MySQL
> To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
> Mail-Followup-To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
> 
> 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.
> HTH
> 
> *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
> http://rjmolesa.com


> -- 
> 
> * * 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
http://rjmolesa.com