HotXLS-dokumentation Innehåll Startsida Översikt TGridToXLS IXLSWorkbook Startsida Innehåll Översikt

UnGroup metod

Promotes a range in an outline (that is, decreases its outline level)

Syntax

procedure UnGroup(Rows: boolean = true); Rows Boolean (Optional). True to ungroup rows; False to ungroup columns. Default value is True

Exempel

This example ungroups three first rows on sheet one
Workbook.Sheets[1].Range['A1', 'A3'].UnGroup; This example is the same to previous
Workbook.Sheets[1].Range['A1', 'A3'].UnGroup(True); This example is the same to previous
Workbook.Sheets[1].Range['A1', 'A3'].Rows.UnGroup; This example is the same to previous
Workbook.Sheets[1].Range['A1', 'A3'].Rows.UnGroup(True); This example ungroups three first columns on sheet one
Workbook.Sheets[1].Range['A1', 'C1'].UnGroup(False); This example is the same to previous
Workbook.Sheets[1].Range['A1', 'C1'].Columns.UnGroup; This example is the same to previous
Workbook.Sheets[1].Range['A1', 'C1'].Columns.UnGroup(False); This example ungroups rows row1 through row2
Workbook.Sheets[1].RCRange[row1, 1, row2, 1].UnGroup; This example ungroups columns col1 through col2
Workbook.Sheets[1].RCRange[1, col1, 1, col2].Columns.UnGroup;

UnGroup metod

Syntax

Exempel

Se även