The xlsLib Library v0.0.1 has been released.
xlsLib is capable of generate Excel spreadsheets with the following features:
* Easy to use, fully object oriented, API.
* Excel 95 format spreadsheets.
* Multiple worksheets.
* All standard font's styles and colors.
* All standard cell's styles, colors and properties.
* All standard cell's border-styles and colors.
* Three basic type of cells:
o Blank.
o Label. The text in labels can be formated in all standard styles.
o Number. All standard number-formats are supported.
* Merged cells.
* Handling of cells using ranges.
It has been implemented as a PHP extension and can be used in Linux and Windows systems.
You can get xlsLib at at http://xlslib.yeico.com
Regards
[Announc.] A PHP extension for generating Excel spreadsheets
Moderator: General Moderators
-
TheBentinel.com
- Forum Contributor
- Posts: 282
- Joined: Wed Mar 10, 2004 1:52 pm
- Location: Columbus, Ohio
Re: [Announc.] A PHP extension for generating Excel spreadsh
Sounds intriguing, but I'd like to see some sample .xls files created by the system available on the web site. I'm curious to see how the output looks in a spreadsheet, but I wouldn't want to go through the installation process just to find out.darioglz wrote:The xlsLib Library v0.0.1 has been released.
The sample scripts looked very cool. (Though the iframe they're displayed in didn't have a scroll bar for me, so I had to select the text to "scroll" it. I have javascript turned off, maybe that broke something that works for everybody else.)
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm
uhh... It has a sample ont eh site. Smae page that the sample script is on. Look near the top where it says:
And click on spreadsheet....
Code: Select all
After installing the xlsLib extension you can try the following script that generates a spreadsheet with 2 worksheets/10x10 cells each:
-
TheBentinel.com
- Forum Contributor
- Posts: 282
- Joined: Wed Mar 10, 2004 1:52 pm
- Location: Columbus, Ohio
Huh, it sure does. Totally missed that.Illusionist wrote:uhh... It has a sample ont eh site. Smae page that the sample script is on.
While I am less able than most to spot stuff like that, the fact that I really wanted it and couldn't find it says it should probably be more prominent.
And the sample data returned is uncomfortable. It's a series of row/column coordinates. I realize that it actually shows how accurately the data was populated, but it would make a better appearance if it looks like a regular spreadsheet, with a column of numbers that add up to something and some labels. Especially if sheet 1 referenced sheet 2 in some way. (I realize this is a 'basic sample', but that doesn't mean it has to be bland and only appealing to techies.)
It looks very cool, though. I'd hate to see someone that wanted to use it turned away because of the things I'm mentioning.
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm
Sorry about the delayed reply:
You can see the xlsLib extension in action here:
http://xlslib.yeico.com/docum/php/qrgdl.php
It will produce a Quick Reference Guide for the php extension.
The script for generating this spreadsheet is also available from http://xlslib.yeico.com/docum/php/quickref.php.
I also want to let you know that the first package release (0.0.1) had a broken old version of the DLL php extension that crashes Apache. This has been fixed in the 0.0.2 distribution package. My apologies for any problem that this could have caused you.
Best regards and thanks for trying xlsLib.
You can see the xlsLib extension in action here:
http://xlslib.yeico.com/docum/php/qrgdl.php
It will produce a Quick Reference Guide for the php extension.
The script for generating this spreadsheet is also available from http://xlslib.yeico.com/docum/php/quickref.php.
I also want to let you know that the first package release (0.0.1) had a broken old version of the DLL php extension that crashes Apache. This has been fixed in the 0.0.2 distribution package. My apologies for any problem that this could have caused you.
Best regards and thanks for trying xlsLib.