Sort Columns w/headers

Topics: User Forum
May 29, 2009 at 8:50 PM

From a text search of the documentation of in 1.6.7 I found reference to:

PHPExcel_Worksheet::sortCellCollection()

I looked thru the documentation, discussions, etc..... and can not find a reference on how to use it.

just this:

method sortCellCollection [line 382]
void sortCellCollection( )

   Sort collection of cells

Sort collection of cells



 
Tags:
access:    public

I want to sort a set of columns say column a to n by column b then d in ascending order with headers in row 1

 

Is this the function for that?

Is there some documentation on this function someplace  ? ? Its not in the 1.6.7 download, nor the file in the download section.....

Thanks in advance.

 

Developer
May 30, 2009 at 1:47 AM

sortCellCollection() is used internally by the classes to sort cells in memory. It does not correspond to any operation in Excel. Therefore it is not mentioned in the "PHP Developer Documentation". In particular, it does not rearrange cells in a sheet.

Unfortunately, we don't have any methods for sorting cells in the sheet like the ones in Excel. At the moment you will have to do this manually in your script using suitable functions in PHP.