Back to Devexpress

ColumnCollection.Group(String, String, Boolean) Method

officefileapi-devexpress-dot-spreadsheet-dot-columncollection-dot-group-x28-system-dot-string-system-dot-string-system-dot-boolean-x29.md

latest2.2 KB
Original Source

ColumnCollection.Group(String, String, Boolean) Method

Groups the specified columns on a worksheet.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void Group(
    string firstColumnHeading,
    string lastColumnHeading,
    bool collapse
)
vb
Sub Group(
    firstColumnHeading As String,
    lastColumnHeading As String,
    collapse As Boolean
)

Parameters

NameTypeDescription
firstColumnHeadingString

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.

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

See how to group data in a worksheet.

See Also

ColumnCollection Interface

ColumnCollection Members

DevExpress.Spreadsheet Namespace