In C#,
If I use the below code for grouping rows, the inner groups are not collapsed by default in the final excel. Only the outer group is collapsed.
- Code: Select all
//InnerGroup1
sheet.GroupByRows(2,3,true);
//InnerGroup2
sheet.GroupByRows(5,6,true);
//Outer Group
sheet.GroupByRows(2,7,true);
So when I expand the outer group, I want the inner groups to be collapsed by default.
How can I achieve this?
Thanks,
Nitin