GrapeCity.Documents.Excel.IOutline

IOutline Interface

Represents an outline on a worksheet.

An IOutline object provides access to worksheet outline settings such as the locations of summary rows and summary columns, the visible outline levels, and grouped row or column information.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IOutline

Public Interface IOutline

Examples

worksheet.Range["2:5"].Group();
IOutline outline = worksheet.Outline;
outline.SummaryRow = SummaryRow.Above;
outline.ShowLevels(1, 0);

Properties

Name	Description
ColumnGroupInfo	Gets information about all groups in the column direction. Use this property to retrieve the column grouping structure in the worksheet outline. Each returned IGroupInfo describes a grouped column range and can be used to inspect the group hierarchy or expand and collapse groups.
RowGroupInfo	Gets information about all groups in the row direction. Returns the top-level row groups in the worksheet outline. Nested row groups can be accessed from the child groups of each returned IGroupInfo.
SummaryColumn	Gets or sets the location of the summary columns in the outline. Use this property to determine whether the summary column is displayed to the left or to the right of the detail columns in a column outline.
SummaryRow	Gets or sets the location of the summary rows in the outline. Use this property to determine whether summary rows are displayed above or below the detail rows for grouped data in the worksheet outline.

Methods

Name	Description
ShowLevels(int, int)	Displays the specified number of row and column levels of an outline. This overload calls ShowLevels(int, int) with the default row and column level values. Use it as a convenience overload when you want the implementation's default outline-level behavior, or call ShowLevels(int, int) to specify explicit row and column levels.

Name

Description

ShowLevels(int, int)

Displays the specified number of row and column levels of an outline.

This overload calls ShowLevels(int, int) with the default row and column level values. Use it as a convenience overload when you want the implementation's default outline-level behavior, or call ShowLevels(int, int) to specify explicit row and column levels.