[thelist] importing .xls files in MySQL
Jon Molesa
rjmolesa at consoltec.net
Thu Jul 24 21:04:43 CDT 2008
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
More information about the thelist
mailing list