Free Support Forum - aspose.com

Grouping Rows using Aspose

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.

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,