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