Free Support Forum - aspose.com

Outlining

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)?

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

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

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.