HotXLS Docs

OutlineLevel property

Returns or sets the current outline level of the specified row or column. Read/write Integer.

Remarks

Level one is the outermost summary level.

Syntax

property OutlineLevel: Integer;

Example

This example sets the outline level for row two on sheet one.

Workbook.Sheets[1].Cells.Rows[2].OutlineLevel := 1;
This example sets the outline level for rows three through five on sheet one.

Workbook.Sheets[1].RCRange[3,1,5,1].Rows.OutlineLevel := 2;
This example sets the outline level for column three on sheet one.

Workbook.Sheets[1].Cells.Columns[3].OutlineLevel := 1;
This example sets the outline level for columns two through five on sheet one.

Workbook.Sheets[1].RCRange[1,2,1,5].Columns.OutlineLevel := 2;

See also

Group method
UnGroup method
ClearOutline method