Page 1 of 1

[Announc.] A PHP extension for generating Excel spreadsheets

Posted: Fri Mar 19, 2004 3:05 pm
by darioglz
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

Re: [Announc.] A PHP extension for generating Excel spreadsh

Posted: Fri Mar 19, 2004 3:11 pm
by TheBentinel.com
darioglz wrote:The xlsLib Library v0.0.1 has been released.
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.

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.)

Posted: Fri Mar 19, 2004 3:23 pm
by Illusionist
uhh... It has a sample ont eh site. Smae page that the sample script is on. Look near the top where it says:

Code: Select all

After installing the xlsLib extension you can try the following script that generates a spreadsheet with 2 worksheets/10x10 cells each:
And click on spreadsheet....Image

Posted: Fri Mar 19, 2004 3:37 pm
by TheBentinel.com
Illusionist wrote:uhh... It has a sample ont eh site. Smae page that the sample script is on.
Huh, it sure does. Totally missed that.

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.

Posted: Fri Mar 19, 2004 3:41 pm
by Illusionist
lol, ya it owuld've been nice to see something other than jsut rows adn columns. It should have at least including some fo the text formatting and cell formatting. But it still looks promising!!

Posted: Tue Mar 23, 2004 12:45 pm
by darioglz
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.

Posted: Wed Apr 14, 2004 8:25 pm
by Pyrite
I get connection refused when try their URL ... :(

Posted: Wed Apr 14, 2004 10:34 pm
by Illusionist
ya same here...