Hi,
I have a query regarding data to be displayed in excel.
I want to show my data to the user upto 5-7 level of hierarchy. Is there a easy way for doing this.
for example my data is
I want to group my data with A,B,C level
| A | |
| A | A1.0 |
| A | A1.1 |
| A | A1.2 |
| A | A1.3 |
| B | |
| B | B1.0 |
| B | B1.1 |
| B | B1.2 |
| C | |
| C | C1.0 |
| C | C1.1 |
|
|
Thanks & Regards
Monisha.
Hi,
We do support grouping data for smart marker feature, if it can be useful for your need. The data list you have shown above (if this is the type of your data list), you may use Smart markers to implement it.
See the document for your complete reference (especially the sup-topic: “Grouping Data”):
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html
Moreover, I am not sure if there is any feature (in MS Excel) that can directly
support 5-7 level of hierarchy data, i.e. you simply provide data and MS
Excel display data in your desired fashion. I think you have to
manually insert hierarchical data into different cells for your
requirement using Aspose.Cells API e.g Cell.PutValue() method in
particular.
We do provide api for row/columns grouping, see the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/groupingungrouping-rows-and-columns.html
Thank you.