Skip to main content
All docs
V24.2

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

Specifies whether the grid exports header bands.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v24.2.dll

NuGet Package: DevExpress.Blazor

#Declaration

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

#Property Value

Type Default Description
Boolean true

true to export header bands; otherwise, false.

#Remarks

Set the ExportHeaderBands property to false to prevent the grid from exporting banded columns.

Razor
<DxGrid @ref="Grid" Data="@Data" >
    <Columns>
        <DxGridBandColumn Caption="Company">
            <Columns>
                <DxGridDataColumn FieldName="ContactName" />
                <DxGridDataColumn FieldName="ContactTitle" />
                <DxGridDataColumn FieldName="CompanyName" />
            </Columns>
        </DxGridBandColumn>
        <DxGridDataColumn FieldName="Country" />
        <DxGridDataColumn FieldName="FullAddress" />
</Columns>
</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() {
            ExportHeaderBands = false,
        });
    }
}
See Also