Outlining

alan_p_warren · July 20, 2006, 7:11pm

Can you please tell me if ASPOSE.Cells supports outlining for Excel spreadsheets (i.e. clicking a '+' to show a group of rows contributing to a subtotal, and clicking '-' to hide them)?

Laurence · July 20, 2006, 7:27pm

Please try to use Cells.GroupRows and Cells.GroupColumns method.

alan_p_warren · July 30, 2006, 9:53pm

Hi Laurence

The GroupRows method simply hides the rows. It does not create a "+"/"-" node to allow the user to expand or collapse the grouped rows.

Thanks

Alan

Laurence · July 30, 2006, 10:08pm

Hi Alan,

How do you use GroupRows method. Please try following piece of code:

Workbook excel = new Workbook();

excel.Worksheets[0].Cells.GroupRows(3, 9);
excel.Worksheets[0].Cells.GroupRows(4, 6);
excel.Worksheets[0].Cells.GroupRows(5, 8);

excel.Save("d:\\test\\abc.xls");

Output file is attached here.