Grouping Rows using Aspose

Aspose.Cells Product Family
1

Hi,

We are using Aspose.Cells.dll (Version 4.5.0.0). We want to group the rows in the excel using aspose similar way it is done in excel workbook (Data -> Group and Outline -> Group).

Any code samples to perform this grouping of the rows will be helpful.

Thanks,

Sanjoy.

2

Hi,

Thank you for considering Aspose.

You may use Cells.GroupRows & Cells.GroupColumns APIs as per your needs. Please see the following documentation links for further details and sample code:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/groupingungrouping-rows-and-columns.html

Also, you may check our online demo regarding grouping / ungrouping rows and columns by using the following link:

http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/rows-and-columns/grouping-rows-and-columns.aspx

Thank You & Best Regards,