want to apply sorting in spreadsheets

Topics: User Forum
Apr 6, 2011 at 6:04 AM

Hi, Iam using PHP Version 5.2.11version , PHPEXCEL 1.7.6 version.

Iam using PHPEXCEL Library to generate Excel worksheets.

Iam successfull in generating  the required spreadsheets.Now I want to apply sorting after the spreadsheets have created.

Is it possible?If yes, Can I able to sort using multiple columns like (A,B,C etc.)

 

Please help.Quick response will be appreciated.

 

Apr 6, 2011 at 12:10 PM
Edited Apr 6, 2011 at 12:10 PM

I think PHPExcel does not sort: http://phpexcel.codeplex.com/discussions/57931

Sorting data in a spreadsheet is a user command that moves data to other cells, therefore it would be best to have PHP sort before generating your spreadsheet, else you would somehow need a macro to run after a user loads your spreadsheet.