RE: [PHP] reading excel file
| From: | Jason Murray | 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