Tedd Sperling
[PHP] Excel import/export via PHP
October 30, 2017 06:30PM
Hi Gang:

Anyone have any code/resources/references regarding importing and exporting Excel data to/from PHP scripts?

Many thanks in advance.

Cheers,

tedd

_______________
tedd sperling
tedd@sperling.com






--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Balbuena, Josue
RE: [PHP] Excel import/export via PHP
October 30, 2017 06:50PM
I'm using this in production.

http://www.maatwebsite.nl/laravel-excel


-----Original Message-----
From: Tedd Sperling [mailto:[email protected]]
Sent: lunes, 30 de octubre de 2017 11:28 a. m.
To: PHP General <[email protected]>
Subject: [PHP] Excel import/export via PHP

Hi Gang:

Anyone have any code/resources/references regarding importing and exporting Excel data to/from PHP scripts?

Many thanks in advance.

Cheers,

tedd

_______________
tedd sperling
tedd@sperling.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
Christoph M. Becker
[PHP] Re: Excel import/export via PHP
October 30, 2017 10:20PM
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
Tony Marston
RE: [PHP] Excel import/export via PHP
October 31, 2017 01:20AM
Try https://github.com/PHPOffice/PHPExcel

Regards,

Tony Marston

-----Original Message-----
From: Tedd Sperling [mailto:[email protected]]
Sent: 30 October 2017 17:28
To: PHP General
Subject: [PHP] Excel import/export via PHP

Hi Gang:

Anyone have any code/resources/references regarding importing and exporting
Excel data to/from PHP scripts?

Many thanks in advance.

Cheers,

tedd

_______________
tedd sperling
tedd@sperling.com


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Bastien Koert
Re: [PHP] Re: Excel import/export via PHP
October 31, 2017 12:10PM
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

> On Oct 30, 2017, at 5:15 PM, Christoph M. Becker <[email protected]> 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
Kevin Kinsey
Re: [PHP] Re: Excel import/export via PHP
October 31, 2017 05:00PM
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 <[email protected]> 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
Sorry, only registered users may post in this forum.

Click here to login