Hi Andrew

It isn't currently supported but Google tells me it should be possible.

There may be a moment this weekend for me to look into this.

A potential workaround is using a template that already has a grouping defined and then just adding more rows within that grouping. I haven't tested that now, but vaguely recall doing something like this previously. I'm not an elephant though so my memory might be incorrect ;) 

Hope this helps.

Hanno

Hi @Andrew Amato,

This is now supported. Update to the latest version of Advanced Excel from the Forge and use the Row_Group action (there's a matching Column_Group for columns). It creates exactly the Excel outline grouping you screenshotted, with the +/- expand/collapse buttons.

Row_Group(Worksheet, StartRow, EndRow, OutlineLevel, Collapsed)

• StartRow / EndRow → the row range to group, e.g. 2 and 5.
• OutlineLevel → nesting level; use 1 for a top-level group (0 also defaults to 1). Use 2, 3… for nested groups.
• Collapsed → False to create it expanded, True to create it already collapsed (rows hidden under the +).

Examples:

• Group rows 2–5: Row_Group(Worksheet, StartRow: 2, EndRow: 5, OutlineLevel: 1, Collapsed: False)
• Nested group inside it (rows 3–4): call Row_Group(Worksheet, 3, 4, 2, False) as well — the level-2 group nests within the level-1 one.
• To remove grouping: Row_Ungroup(Worksheet, StartRow, EndRow).

Call it after writing your data, then Workbook_GetBinaryData. Hope this helps!