Web lists-archives.com

Re: [PHP] Re: Excel import/export via PHP




On Tue, Oct 31, 2017 at 07:08:25AM -0400, Bastien Koert wrote:
> Hey Tedd,
> 
> I???ve used the phpExcel library in the past to handle this. Working with excel is pretty easy with the library. 
> 
> I also have some code at work for reading in excel that I can post later 
> 
> Thanks,
> 
> Bastien
> 

+1 for PHPExcel.  I dreaded having to "learn another system", but found it
pretty easy to integrate and have used it more than once.  Do pay attention
to the requires for RAM and Disk space if you're dealing with a non-trivial
amount of data in a sheet (we found it takes quite a bit of server to output
a sheet with several columns and 50-100 thousand rows).

Kevin Kinsey
Asay Media


> > On Oct 30, 2017, at 5:15 PM, Christoph M. Becker <cmbecker69@xxxxxx> wrote:
> > 
> >> On 30.10.2017 at 18:27, Tedd Sperling wrote:
> >> 
> >> Anyone have any code/resources/references regarding importing and exporting Excel data to/from PHP scripts?
> > 
> > If it is only about the actual *data*, consider using CSV as
> > intermediate format, which is easily processible with fputcsv() and
> > fgetcsv(), respectively.
> > 
> > -- 
> > Christoph M. Becker
> > 
> > -- 
> > 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