Reference>IXLSRange>OutlineLevel

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

Remarks

Level one is the outermost summary level.

property OutlineLevel: integer;

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;