Back to Devexpress

DxTreeList.ExportToCsvAsync(Stream, TreeListCsvExportOptions) Method

blazor-devexpress-dot-blazor-dot-dxtreelist-dot-exporttocsvasync-x28-system-dot-io-dot-stream-devexpress-dot-blazor-dot-treelistcsvexportoptions-x29.md

latest3.5 KB
Original Source

DxTreeList.ExportToCsvAsync(Stream, TreeListCsvExportOptions) Method

Exports TreeList data to a stream in CSV format.

Namespace : DevExpress.Blazor

Assembly : DevExpress.Blazor.v25.2.dll

NuGet Package : DevExpress.Blazor

Declaration

csharp
public Task ExportToCsvAsync(
    Stream stream,
    TreeListCsvExportOptions options = null
)

Parameters

NameTypeDescription
streamStream

The target stream for export.

|

Optional Parameters

NameTypeDefaultDescription
optionsTreeListCsvExportOptionsnull

An object that contains export options.

|

Returns

TypeDescription
Task

The task that is completed when the file is exported.

|

Remarks

Call the ExportToCsvAsync method to export data in CSV format. Note that only data cell values are exported - summaries and cell style settings are ignored.

The method overloads allow you to write the result to a stream (current overload) or to a file downloaded to a client machine (ExportToCsvAsync(String, TreeListCsvExportOptions)). Methods accept a TreeListCsvExportOptions object as a parameter. You can use this parameter to set up export settings.

For additional information about data export in the TreeList component, refer to the following topic: Export Blazor TreeList Data to CSV.

Run Demo: TreeList - Export

Important

Security Considerations

Exported data can contain executable content. To prevent possible security vulnerabilities, set the EncodeExecutableContent property to true to enclose potentially dangerous content in quotation marks prior to exporting it to the CSV format. To learn more, see the property description.

Example

The following example uses a file stream to export TreeList data to the XLSX file:

razor
<DxButton Text="Export to CSV" Click="ExportCSV_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 ExportCSV_Click() {
        string path = @"C:\MyProjects\MyFile.csv";
        FileStream fs = File.OpenWrite(path);
        await MyTreeList.ExportToCsvAsync(fs);
        fs.Dispose();
    }
}

Implements

ExportToCsvAsync(Stream, TreeListCsvExportOptions)

See Also

DxTreeList Class

DxTreeList Members

DevExpress.Blazor Namespace