Back to Devexpress

DxGrid.ExportToCsvAsync(Stream, GridCsvExportOptions) Method

blazor-devexpress-dot-blazor-dot-dxgrid-dot-exporttocsvasync-x28-system-dot-io-dot-stream-devexpress-dot-blazor-dot-gridcsvexportoptions-x29.md

latest3.4 KB
Original Source

DxGrid.ExportToCsvAsync(Stream, GridCsvExportOptions) Method

Exports grid 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,
    GridCsvExportOptions options = null
)

Parameters

NameTypeDescription
streamStream

The target stream for grid data export.

|

Optional Parameters

NameTypeDefaultDescription
optionsGridCsvExportOptionsnull

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 grid data in CSV format. Note that only data cell values are exported - group rows, summaries, and cell style settings are ignored.

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

Run Demo: Grid - Export

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

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.

Large Data Limitations

If the grid is bound to a GridDevExtremeDataSource object, the following limitations apply:

  • If you want to export selected rows only, specify the KeyFieldName property.
  • Grouped data, and filtered and sorted selected rows may differ in the resulting document. This happens because export depends on database collation. For example, the same string with different capitalization may form multiple groups in the exported document. The Grid component puts such values into a single group.

Implements

ExportToCsvAsync(Stream, GridCsvExportOptions)

See Also

DxGrid Class

DxGrid Members

DevExpress.Blazor Namespace