[Announc.] A PHP extension for generating Excel spreadsheets

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
darioglz
Forum Newbie
Posts: 2
Joined: Fri Mar 19, 2004 3:05 pm

[Announc.] A PHP extension for generating Excel spreadsheets

Post 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
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

Post 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.)
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post 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
TheBentinel.com
Forum Contributor
Posts: 282
Joined: Wed Mar 10, 2004 1:52 pm
Location: Columbus, Ohio

Post 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.
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post 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!!
darioglz
Forum Newbie
Posts: 2
Joined: Fri Mar 19, 2004 3:05 pm

Post 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.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

I get connection refused when try their URL ... :(
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

ya same here...
Post Reply