Read/write Excel spreadsheet libraries

Read/write Excel spreadsheet libraries

am 30.05.2005 19:56:00 von gcook

Hi,

Are there any commonly used PHP libraries for reading/writing Excel
spreadsheets? We're rewriting an old perl app into php. The perl app
was previously using Spreadsheet::WriteExcel, we need to duplicate the
functionality.

Thanks!

-glenn

Re: Read/write Excel spreadsheet libraries

am 31.05.2005 00:09:55 von Chris Hope

gcook wrote:

> Are there any commonly used PHP libraries for reading/writing Excel
> spreadsheets? We're rewriting an old perl app into php. The perl app
> was previously using Spreadsheet::WriteExcel, we need to duplicate the
> functionality.

If you're using Windows you can use Com to read Excel:
http://forums.devarticles.com/archive/t-9352/php-read-excel

There's a PEAR package for writing Excel spreadsheets:
http://pear.php.net/package/Spreadsheet_Excel_Writer

Another one for writing spreadsheets is here:
http://www.cnovak.com/biff/index.htm

I've used the last one myself and it makes it very easy to create
spreadsheets. It used to be free but now seems to be very expensive.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

Re: Read/write Excel spreadsheet libraries

am 31.05.2005 00:11:10 von gcook

The pear packages are already installed on my server for other things,
and since it's the php version of Spreadsheet::WriteExcel (which is
exactly what the perl program we're converting from is using right now)
I think that's exactly what we're looking for!

Thank you.



Chris Hope wrote:

>
> There's a PEAR package for writing Excel spreadsheets:
> http://pear.php.net/package/Spreadsheet_Excel_Writer
>

Followup Question Re: Read/write Excel spreadsheet libraries

am 31.05.2005 16:11:27 von gcook

Is there anything like Spreadsheet::ParseExcel for PHP - to read Excel
files? It seems the pear libraries only allow 'write' type of functions.

Thanks for your help.

glenn


gcook wrote:
> Hi,
>
> Are there any commonly used PHP libraries for reading/writing Excel
> spreadsheets? We're rewriting an old perl app into php. The perl app
> was previously using Spreadsheet::WriteExcel, we need to duplicate the
> functionality.
>
> Thanks!
>
> -glenn