TreeListExportCustomizeCellEventArgs.Value Property

Specifies the value of the current cell.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v25.1.dll

NuGet Package: DevExpress.Blazor

Declaration

public object Value { get; set; }

Property Value

Type	Description
Object	The cell value.

Remarks

The CustomizeCell action allows you to customize a cell in the exported file. Use the Value property to get or set the value of the currently processed cell.

Set the Handled property to true to apply the changes made in the action handler to the cell.

The following example modifies the Employee Name column value:

@using DevExpress.Export

<DxButton Text="Export to XLSX" Click="ExportXlsx_Click" />

<DxTreeList Data="TreeListData" KeyFieldName="Id" ParentKeyFieldName="ParentId" @ref="MyTreeList">
    <Columns>
        <DxTreeListDataColumn FieldName="Name" Caption="Task" />
        <DxTreeListDataColumn FieldName="EmployeeName" />
        <DxTreeListDataColumn FieldName="StartDate" />
        <DxTreeListDataColumn FieldName="DueDate" />
    </Columns>
</DxTreeList>

@code {
    ITreeList MyTreeList { get; set; }

    async Task ExportXlsx_Click() {
        await MyTreeList.ExportToXlsxAsync("ExportResult", new TreeListXlExportOptions() {
            CustomizeCell = OnCustomizeCell
        });
    }
    void OnCustomizeCell(TreeListExportCustomizeCellEventArgs args) {
        if (args.AreaType == SheetAreaType.DataArea && args.ColumnFieldName == "EmployeeName") {
            args.Value = (string)args.Value + " is responsible";
        }
        args.Handled = true;
    }
}