GridXlExportOptions.ExportGroupSummaries Property

Specifies whether the grid exports group footer summaries.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v23.2.dll

NuGet Package: DevExpress.Blazor

Declaration

[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.

<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.