Free Support Forum - aspose.com

[Request] Group feature

Hi Everyone,

I was wondering if the Aspose’s team has planned to develop the feature of group.
[ For further details see “group-data-excel-2007.png” ]

Once this button is clicked it gives a “hierarchy” like this one:
[ See
“grouping-large-columns-row.jpg” ]

If it is planned, can you tell me when it will be developped ?

Thanks in advance,

Best Regards,
Louis.


Hi Louis,


Thank you for sharing the snapshots.
What I understand from these snapshots is that you need to implement the Grouping with in the Grouping. If I am correct then Aspose.Cells for .NET API already supports this feature. I have attached my sample Excel file for your reference, that I produced through my below source code.

Please feel free to write back.

C# Code

var book = new Workbook();

var sheet = book.Worksheets[0];

var cells = sheet.Cells;

cells.GroupRows(0, 10);

cells.GroupRows(4, 7);

cells.GroupColumns(0, 10);

cells.GroupColumns(4, 7);

book.Save(“C:\temp\grouping.xlsx”,SaveFormat.Xlsx);