This example demonstrates how to export DevExpress Blazor Grid data to an XLSX file and customize the export result.
Set a column's ExportEnabled property to false
to prevent the Grid from exporting this column. To export data to an XLSX file, call the Grid's ExportToXlsxAsync method. The method accepts a GridXlExportOptions object as a parameter. Specify the parameter's properties to set up export settings.
The code example sets the following GridXlExportOptions
properties:
CustomizeCell
Allows you to customize a cell in the resulting document based on custom conditions.
CustomizeColumn
Allows you to customize a column in the resulting document.
CustomizeSheet
Allows you to customize sheet settings in the resulting document.
ExportDisplayText
Specifies whether the Grid exports cell values or display text strings.
ExportUnboundExpressionAsFunction
Specifies whether the grid exports an unbound column expression as a function or as a calculated value.
RowExporting
Allows you to filter exported data.
SheetName
Specifies a name of the sheet in the resulting document.
(you will be redirected to DevExpress.com to submit your response)