PHPExcel 1.6.7 installed, now where's the API?

Apr 30, 2009 at 6:14 AM
I've spent a good amount of time installing, adding missing lib and .so
(zlib  and  pecl zip) and can now run the hello world sample application.

I have a couple of questions as this is all new to me.

I am currently using the PEAR Excel_Spreadsheet_Writer and want to replace that with an API that allows us to do stuff like AutoFilter.
(I eventually found your PHPExcel project).

So, there must be a public method, in some class, called something like :   setAutoFilter(  ... )
I know that the AutoFilter is not available in Excel5 and that I need to use the Excel7 class.

Where is the API?  I see the source files, do I have to wade through them to find this method?

What about the "tests" package?  Is this a directory in the 1.6.7 download?   I have no such package or directory in my installation.

I would love to browse the sample code, but where is it?

Thanks for any help, and nice work!

John
Developer
Apr 30, 2009 at 10:53 AM
Hmm... There should be a Tests folder and a Documentation/API folder together with the downloaded release 1.6.7 ?

Here is the direct download link:
http://phpexcel.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=10716#DownloadId=66231

Apr 30, 2009 at 4:04 PM
Koyama,

Here is the contents of my installation:

[root@localhost pear]# cd PHPExcel
[root@localhost PHPExcel]# ls

Calculation             IComparable.php      Style
Calculation.php         IOFactory.php        Style.php
Cell                    NamedRange.php       Worksheet
Cell.php                Reader               WorksheetIterator.php
Comment.php             ReferenceHelper.php  Worksheet.php
DocumentProperties.php  RichText             Writer
DocumentSecurity.php    RichText.php
HashTable.php           Shared


No doc or tests dir

HTH,

JJ
Apr 30, 2009 at 4:09 PM
Koyoma,

I now see that it's the PEAR PHPExcel  1.6.7 download that doesn't have the doc or test dirs.

The "1.6.7.zip" does have the doc and tests dir.  

Is that the way it should be?

Thanks for the link.
JJ
Developer
Apr 30, 2009 at 4:12 PM
Ah, that explains it. Yes, it is supposed to be that way. Documentation is separate from the PEAR package.