Grouping and Ungrouping Rows and Columns

EPPlus can group rows and columns and add buttons to expand or collape the rows/columns.

Grouping of rows and columns is set by the OutlineLevel property. EPPlus 6.1 provides several new methods to group and expand and collapse rows and columns.

Method	Description
Group()	Groups rows or columns together. Adds one to OutlineLevel property from 1-8
Ungroup()	Ungroups rows or columns. Subtracts one from OutlineLevel property
CollapseChildren()	Collapses and hides the children of the row/columns.
ExpandChildren()	Expands and shows the children of the row/columns.
SetVisibleOutlineLevel(int)	Sets the visible level for a range of rows/columns