ExcelFile.CollapseOutlineCols Method

Overloads

ExcelFile.CollapseOutlineCols(Int32, TCollapseChildrenMode)

Collapses or expands the column outlines in a sheet to the specified level. It is equivalent to pressing the numbers at the left of the outline gutter in Excel.

Syntax

Namespace: FlexCel.Core

public void CollapseOutlineCols(Int32 level, TCollapseChildrenMode collapseChildren)

Parameters

<-> Parameter Type Description
level Int32 Level that we want to display from the outline. (1 based).
For example, setting Level = 3 is the same as pressing the "3" number at the left of the outline gutter in Excel.
Setting Level = 1 will collapse all groups, Level = 8 will expand all groups.
collapseChildren TCollapseChildren​Mode Determines if the children of the collapsed nodes will be collapsed too.

See also

ExcelFile.CollapseOutlineCols(Int32, TCollapseChildrenMode, Int32, Int32)

Collapses or expands the column outlines in a sheet to the specified level. It is equivalent to pressing the numbers at the top of the outline gutter in Excel.

Syntax

Namespace: FlexCel.Core

public abstract void CollapseOutlineCols(Int32 level, TCollapseChildrenMode collapseChildren, Int32 firstCol, Int32 lastCol)

Parameters

<-> Parameter Type Description
level Int32 Level that we want to display from the outline. (1 based).
For example, setting Level = 3 is the same as pressing the "3" number at the left of the outline gutter in Excel.
Setting Level = 1 will collapse all groups, Level = 8 will expand all groups.
collapseChildren TCollapseChildren​Mode Determines if the children of the collapsed nodes will be collapsed too.
firstCol Int32 This defines the first column of the range to collapse/expand. Only columns inside that range will be modified.
lastCol Int32 This defines the last column of the range to collapse/expand. Only columns inside that range will be modified.

See also