ColumnCollection.Group(String, String, Boolean) Method

Groups the specified columns on a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Group(
    string firstColumnHeading,
    string lastColumnHeading,
    bool collapse
)

VB.NET

Sub Group(
    firstColumnHeading As String,
    lastColumnHeading As String,
    collapse As Boolean
)

Parameters

Name	Type	Description
firstColumnHeading	String	The heading of the first column to group.
lastColumnHeading	String	The heading of the last column to group.
collapse	Boolean	true, if the created group is collapsed; otherwise, false.

Remarks

The method’s firstColumnHeading and lastColumnHeading parameters require column headings in the A1 reference style.

C#

// Group four columns and expand the group.
worksheet.Columns.Group("C", "F", false);

VB.NET

' Group four columns and expand the group.
worksheet.Columns.Group("C", "F", False)

See how to group data in a worksheet.