NativeExcel2 for .Net Developer's Reference

IRange.UngroupMethod

Decreases the outline level of rows in the specifed range.

[Visual Basic]
SubUngroup()
[C#]
voidUngroup();
[C++]
voidUngroup();
[JScript]
functionUngroup();

Example

This example ungroups three first rows on sheet one.

[C#]
 book.Worksheets[1].Range["A1:A3"].Ungroup();
[VisualBasic]
 book.Worksheets(1).Range("A1:A3").Ungroup()
[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:A3"]->Ungroup();
This example is the same as the previous.
[C#]
 book.Worksheets[1].Range["A1:A3"].Rows.Ungroup();
[VisualBasic]
 book.Worksheets(1).Range("A1:A3").Rows.Ungroup()
[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:A3"]->Rows->Ungroup();
This example ungroups three first columns on sheet one.
[C#]
 book.Worksheets[1].Range["A1:C1"].Columns.Ungroup();
[VisualBasic]
 book.Worksheets(1).Range("A1:C1").Columns.Ungroup()
[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:C1"]->Columns->Ungroup();

See Also

IRange Interface | NativeExcel Namespace | IRangeColumns.Ungroup Method | Group Method | OutlineLevel Property | IRangeColumns.OutlineLevel Property | ClearOutline Method