Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

GridXlExportOptions.ExportGroupSummaries Property

Specifies whether the grid exports group footer summaries.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v24.2.dll

NuGet Package: DevExpress.Blazor

#Declaration

C#
[DefaultValue(true)]
public bool ExportGroupSummaries { get; set; }

#Property Value

Type Default Description
Boolean true

true to export group footer summaries; otherwise, false.

#Remarks

When a group summary’s FooterColumnName property is specified, the grid displays the summary in the group footer and exports it to XLS and XLSX files.

Set the ExportGroupSummaries property to false to prevent the grid from exporting group footer summaries.

razor
<DxGrid @ref="Grid" Data="@Data" ShowGroupPanel="true" >
    <Columns>
        <DxGridDataColumn FieldName="ContactName" />
        <DxGridDataColumn FieldName="ContactTitle" />
        <DxGridDataColumn FieldName="CompanyName" />
        <DxGridDataColumn FieldName="Country" GroupIndex="0" />
    </Columns>
    <GroupSummary>
        <DxGridSummaryItem FieldName="ContactName" SummaryType="GridSummaryItemType.Count" 
                           FooterColumnName="Country" />
    </GroupSummary>
</DxGrid>
<DxButton Text="Export to XLSX" Click="ExportXlsx_Click" />

@code {
    IEnumerable<object> Data { get; set; }
    IGrid Grid { get; set; }
    protected override async Task OnInitializedAsync() {
        Data = await NwindDataService.GetCustomersAsync();
    }
    async Task ExportXlsx_Click() {
       await Grid.ExportToXlsxAsync("ExportResult", new GridXlExportOptions() {
            ExportGroupSummaries = false,
        });
    }
}

Use the ExportTotalSummaries property to specify whether the grid exports total summaries.

See Also