Group Rows and Columns of Worksheet

Possible Usage Scenarios

Aspose.Cells allows you to group rows and columns in a worksheet using Cells.GroupRows() and Cells.GroupColumns() methods.

Group Rows and Columns of Worksheet

The following sample code shows how to group rows and columns. It groups the rows and columns up to the 3rd level. Please check the output excel file generated with this code. It has two worksheets, the first one contains the grouping of rows and the second one contains the grouping of columns. Please also see the screenshot showing the grouping of rows in its first worksheet.

todo:image_alt_text

Sample Code