ExcelScript.GroupOption enum

Remarks

Used by

• ExcelScript.Range: group, hideGroupDetails, showGroupDetails, ungroup

Examples

/**
 * This script creates a two-level column-based outline on Sheet1.
 */
function main(workbook: ExcelScript.Workbook) {
 // Group columns A-F in the worksheet named Sheet1.
 const sheet = workbook.getWorksheet("Sheet1");
 const firstLevel = sheet.getRange("A:F");
 firstLevel.group(ExcelScript.GroupOption.byColumns);
 
 // Create a second level to the outline by grouping subsections.
 sheet.getRange("A:B").group(ExcelScript.GroupOption.byColumns);
 sheet.getRange("D:E").group(ExcelScript.GroupOption.byColumns);
}

Fields