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

GridExportCustomizeCellEventArgs.AreaType Property

Returns the type of area where the current cell is placed.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v24.2.dll

NuGet Package: DevExpress.Blazor

#Declaration

C#
public SheetAreaType AreaType { get; set; }

#Property Value

Type Description
DevExpress.Export.SheetAreaType

The area type.

#Remarks

The CustomizeCell action allows you to customize a cell in the exported file. The AreaType property identifies the type of area that contains the processed cell.

Grid - Area types

The AreaType property can return the following values:

Header
Identifies a column header. Use the ColumnFieldName property to get the name of the data source field assigned to the column that contains the processed cell.
GroupHeader
Identifies a group row. Use the GroupFieldName property to get the name of the data source field bound to the processed group column.
DataArea
Identifies a data row. Use the DataItem property to get the data source item that is bound to the processed row.
GroupFooter
Identifies a group footer row. Use the GroupFieldName property to get the name of the data source field bound to the processed group column. The SummaryItem property returns information about the summary item in the processed group footer cell.
TotalFooter
Identifies the grid footer row. Use the SummaryItem property to get information about the summary item in the processed footer cell.
Razor
@using DevExpress.Export

<DxGrid @ref="Grid"
        Data="@Data"
        SelectionMode="GridSelectionMode.Multiple">
    <Columns>
        <DxGridSelectionColumn Width="60px" AllowSelectAll="true" />
        <DxGridDataColumn FieldName="ContactName" Width="15%" />
        <DxGridDataColumn FieldName="ContactTitle" Width="15%" />
        <DxGridDataColumn FieldName="CompanyName" Width="20%" />
        <DxGridDataColumn FieldName="Country" Width="15%" />
        <DxGridDataColumn FieldName="FullAddress" UnboundType="GridUnboundColumnType.String" 
                          UnboundExpression="[City] + ' - ' + [PostalCode] + ' - ' + [Address]" />
    </Columns>
</DxGrid>

<DxButton Text="Export to XLS" Click="ExportXls_Click" />

@code {
    IEnumerable<object> Data { get; set; }
    IGrid Grid { get; set; }
    protected override async Task OnInitializedAsync() {
        Data = await NwindDataService.GetCustomersAsync();
    }
    async Task ExportXls_Click() {
       await Grid.ExportToXlsAsync("ExportResult", new GridXlExportOptions() {
            ExportSelectedRowsOnly = true,
            CustomizeCell = OnCustomizeCell
        });
    }
    void OnCustomizeCell (GridExportCustomizeCellEventArgs args) {
        if(args.ColumnFieldName == "ContactName" && args.AreaType == SheetAreaType.DataArea)
            args.Formatting.Font = new XlCellFont() { Italic = true };
        args.Handled = true;
    }
}

Run Demo: Grid - Export Data

See Also