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