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

Group metod

Demotes the Range (increases its outline level)

Syntax

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

Exempel

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

Group metod

Syntax

Exempel

Se även