TreeListExportOptions Class

The base class for the TreeListXlExportOptions and TreeListCsvExportOptions classes. Contains common options that define how a document is exported.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v25.2.dll

NuGet Package: DevExpress.Blazor

Declaration

public abstract class TreeListExportOptions :
    GridExportOptionsBase

Remarks

When you export data, descendants of the TreeListExportOptions class allow you to customize the settings of the exported data and the exported document.

Read Tutorial: Export Data Run Demo: Export Data

<DxTreeList @ref="TreeList"
            Data="TreeListData"
            ChildrenFieldName="Satellites"
            CssClass="max-h-480">
    <Columns>
        <DxTreeListSelectionColumn Width="60px" AllowSelectAll="true" />
        <DxTreeListDataColumn FieldName="Name" ExportWidth="240"/>
        <DxTreeListDataColumn FieldName="TypeOfObject" Caption="Type" FilterRowOperatorType="TreeListFilterRowOperatorType.Equal" ExportWidth="160">
            <EditSettings>
                <DxComboBoxSettings Data="TreeListRenderHelper.SpaceObjectTypes" SearchMode="@ListSearchMode.AutoSearch"
                                    SearchFilterCondition="@ListSearchFilterCondition.Contains"/>
            </EditSettings>
        </DxTreeListDataColumn>
        <DxTreeListDataColumn FieldName="Mass10pow21kg" Caption="Mass, kg" DisplayFormat="N2">
            <HeaderCaptionTemplate>Mass, 10<sup>21</sup> &#215; kg</HeaderCaptionTemplate>
        </DxTreeListDataColumn>
        <DxTreeListDataColumn FieldName="MeanRadiusInKM" Caption="Radius, km" DisplayFormat="N2" ExportWidth="180"/>
        <DxTreeListDataColumn FieldName="Volume10pow9KM3" Caption="Volume, km³" DisplayFormat="N2">
            <HeaderCaptionTemplate>Volume, 10<sup>9</sup> &#215; km<sup>3</sup></HeaderCaptionTemplate>
        </DxTreeListDataColumn>
        <DxTreeListDataColumn FieldName="SurfaceGravity" Caption="Gravity" DisplayFormat="N2" ExportWidth="120">
            <HeaderCaptionTemplate>Gravity, m/s<sup>2</sup></HeaderCaptionTemplate>
        </DxTreeListDataColumn>
    </Columns>
    <TotalSummary>
        <DxTreeListSummaryItem SummaryType="TreeListSummaryItemType.Count" FieldName="Name" />
    </TotalSummary>
    <ToolbarTemplate>
        <DxToolbar>
            <DxToolbarItem Text="Export to XLSX" Click="ExportXlsx_Click" BeginGroup="true" />
            <DxToolbarItem Text="Export to XLS" Click="ExportXls_Click" BeginGroup="true" />
            <DxToolbarItem Text="Export to CSV" Click="ExportCsv_Click" BeginGroup="true" />
            <DxToolbarItem Text="Export to PDF" Click="ExportPdf_Click" BeginGroup="true" />
            <DxToolbarItem Alignment="ToolbarItemAlignment.Right" BeginGroup="true">
                <Template Context="_">
                    <DxCheckBox @bind-Checked="@ExportSelectedRowsOnly">Export Selected Rows Only</DxCheckBox>
                </Template>
            </DxToolbarItem>
        </DxToolbar>
    </ToolbarTemplate>
</DxTreeList>

@code {
    ITreeList TreeList { get; set; }
    object TreeListData { get; set; }
    bool ExportSelectedRowsOnly { get; set; }

    protected override void OnInitialized() {
        TreeListData = SpaceObjectDataProvider.GenerateData();
    }
    async Task ExportXlsx_Click() {
        await TreeList.ExportToXlsxAsync("ExportResult", new TreeListXlExportOptions() {
            ExportSelectedRowsOnly = ExportSelectedRowsOnly,
            SelectedRowsExportMode = TreeListSelectedRowsExportMode.KeepHierarchy,
            CustomizeCell = OnCustomizeXlCell
        });
    }
    async Task ExportXls_Click() {
        await TreeList.ExportToXlsAsync("ExportResult", new TreeListXlExportOptions() {
            ExportSelectedRowsOnly = ExportSelectedRowsOnly,
            SelectedRowsExportMode = TreeListSelectedRowsExportMode.KeepHierarchy,
            CustomizeCell = OnCustomizeXlCell
        });
    }
    async Task ExportCsv_Click() {
        await TreeList.ExportToCsvAsync("ExportResult", new TreeListCsvExportOptions() {
            ExportSelectedRowsOnly = ExportSelectedRowsOnly
        });
    }
    void OnCustomizeXlCell(TreeListExportCustomizeCellEventArgs args) {
        if(args.ColumnFieldName == "TypeOfObject" && args.AreaType == SheetAreaType.DataArea)
            args.Formatting.Font = new XlCellFont() { Italic = true };
        args.Handled = true;
    }
}

Inheritance

Object

DevExpress.Blazor.Grid.Internal.GridExportOptionsBase

TreeListExportOptions

TreeListCsvExportOptions

TreeListXlExportOptions