[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.
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
More information about the thelist
mailing list