Export Modes

• Jul 07, 2022

The ASPxGridView control can export data in DataAwareand WYSIWYG modes.

You can specify the export mode at design time (the ExcelExportMode property) or send the ExportType parameter to an export method at runtime.

Design Time

<dx:ASPxGridView ID="grid" runat="server" DataSourceID="CategoriesDataSource" KeyFieldName="CategoryID">
    <SettingsExport ExcelExportMode="WYSIWYG" />
    <%--...--%>

Run Time C#

ASPxGridView1.ExportXlsxToResponse(new XlsxExportOptionsEx { ExportType = ExportType.WYSIWYG });

Run Time VB.NET

ASPxGridView1.ExportXlsxToResponse(New XlsxExportOptionsEx With {
    .ExportType = ExportType.WYSIWYG
})

DataAware Mode

Supported formats: XLS and XLSX.

This mode maintains the following data shaping settings in the exported document:

• Data grouping.
• Data sorting and filtering.
• Totals and group summaries.
• Format conditions.
• Data validation for combo-box columns.
• Fixed columns.

Run Demo: Grid - Excel Data Aware Export

API to Customize the Exported Grid Elements

• ExportCellStyle
• XlsExportOptionsEx.CustomizeCell
• XlsxExportOptionsEx.CustomizeCell

Unsupported Features

• Master-detail grid export.
• Preview row export.

Unsupported API

• ReportHeader
• ReportFooter
• PageHeader
• PageFooter
• ExportRenderBrick
• StylesExport

WYSIWYG Mode

Supported formats: PDF, RTF, CSV, XLS, XLSX, and DOCX.

API to Customize the Exported Grid Elements

• ExportRenderBrick
• StylesExport

Unsupported Features

• Rich text formatting is ignored in ReportHeader and ReportFooter property values.

Unsupported API

• Landscape
• PaperKind