Re: [PHP] reading excel file
Hi , I converted ".CSV" (comma delimited) file to MySQL it 's easy to use it... "Tyler Longren" To: "php-general" <[EMAIL PROTECTED]> Subject: [PHP] reading excel file 03.04.2002 04:30 Hello List, 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. Thanks for any suggestions, Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] reading excel file
If you are running your server on windows, you may also have the option of using COM to access Excel to open the file and read the information contained in each cell, See http://www.php.net/manual/en/ref.com.php Warren Vail Tools, Metrics & Quality Processes (415) 667-7814 Pager (877) 774-9891 215 Fremont 02-658 -Original Message- From: Jason Murray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 5:33 PM To: 'Tyler Longren'; php-general Subject: RE: [PHP] reading excel file > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] reading excel file
> If it's possible, it probably better to deal with each line > by itself, rather than try to load to whole file into memory. Good point. Shared server admins probably hate me. ;) J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] reading excel file
> Thanks Jason, that is a pretty good idea. Any idea how well > PHP handles large ammounts of data like that? There'll be about > 25,000 lines in every excel file, and they come in groups of 5 or 6. I've rigged up an import script for similar functions before, it seems to run ok... it really depends on the specs of the server you're running it on. If you notice slowness, consider raising the timeout by X seconds per Y lines, then you can judge the size of the incoming file and change how long PHP gets to run. J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] reading excel file
If it's possible, it probably better to deal with each line by itself, rather than try to load to whole file into memory. Martin -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:37 AM To: Jason Murray; php-general Subject: Re: [PHP] reading excel file Thanks Jason, that is a pretty good idea. Any idea how well PHP handles large ammounts of data like that? There'll be about 25,000 lines in every excel file, and they come in groups of 5 or 6. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: "Jason Murray" <[EMAIL PROTECTED]> To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "php-general" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 7:32 PM Subject: RE: [PHP] reading excel file > > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading excel file
Thanks Jason, that is a pretty good idea. Any idea how well PHP handles large ammounts of data like that? There'll be about 25,000 lines in every excel file, and they come in groups of 5 or 6. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Original Message - From: "Jason Murray" <[EMAIL PROTECTED]> To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "php-general" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 7:32 PM Subject: RE: [PHP] reading excel file > > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] reading excel file
> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php