RE: [PHP] reading excel file

From: Date: Wed, 03 Apr 2002 01:32:32 +0000
Subject: RE: [PHP] reading excel file
Groups: php.general 
Request: Send a blank email to php-general+get-91241@lists.php.net to get a copy of this message
> Has anyone ever converted an excel file over to a MySQL database > via PHP? I'm currently doing it with perl, and this isn't a very > good option for me. The client needs to login to a server via ssh > every time they want to put data from their excel file to mysql. > I'd like to find some way to do it through a web browser. If you can get them to save the Excel file as tab-delimited, you could just read it, explode on \t and assemble your SQL insert statements. Failing that, you could continue to use the Perl script but accept the Excel file as a HTTP upload, and have PHP run the Perl script. J

« previous php.general (#91241) next »