Use of PHPExcel Subtotal

Topics: Developer Forum, User Forum
Feb 16, 2010 at 12:23 AM

Hi All

I have searched the site and other areas on the web first, but I have not found an answer to the issue I have, hence this submission.

Basically I want to create a spreadsheet from a database source of data, managed that and PHPExcel helps you do it very well, thanks PHPExcel team.

However I am trying to create a subtotal, which I am able to create the subtotal rows, however not able to generate the expand and minimise features that would normally appear when you select the subtotal feature within excel, or define which column to trigger a subtotal.

Many thanks



Feb 16, 2010 at 10:29 PM

Take a look at section "Group/outline a row" in the "PHPExcel developer documentation". I believe those are the key to the expand and minimize features you are looking for.