HotXLS 文件

UnGroup 方法

提升大綱中的範圍(即降低其大綱層級)

語法

procedure UnGroup(Rows: boolean = true);
Rows 布林值 (Optional). True 到 ungroup 列; False 到 ungroup 欄. 預設值 是 True

範例

此範例取消工作表一 1 到 4 列的分組

Workbook.Sheets[1].Range['A1', 'A3'].UnGroup;
Group 方法

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;

另請參閱

Group method
ClearOutline method
OutlineLevel property