Skip to main content
All docs
V24.1
Tab

ASPxGridViewExportSettings.ExcelExportMode Property

Specifies the export mode when saving grid data to XLS and XLSX formats.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v24.1.dll

NuGet Package: DevExpress.Web

Declaration

[DefaultValue(ExportType.Default)]
public ExportType ExcelExportMode { get; set; }

Property Value

Type Default Description
ExportType Default

The export mode.

Available values:

Name Description
Default

The default export mode.

For the ExportSettings.DefaultExportType property, the Default value is equivalent to the DataAware value.

If the XlsxExportOptionsEx.ExportType, XlsExportOptionsEx.ExportType or CsvExportOptionsEx.ExportType property is set to Default, the actual export mode is specified by the ExportSettings.DefaultExportType property.

DataAware

Export type that uses a new data export engine that features improved performance and memory usage. When exporting to XLS and XLSX formats, specific data-shaping options (e.g., summaries, filtering, sorting, data groups and lookup values) of a source control are retained in the export output. When exporting to CSV format, the control’s data shaping options are not included in the export document, which simplifies subsequent analysis and processing of text data.

The layout of control elements may not be retained in the export document. Other limitations also apply.

Not all controls support the DataAware export mode.

WYSIWYG

Export type that uses the export engine of the XtraPrinting library. When exporting to XLS and XLSX formats, the layout of control elements is retained in the export document; specific data shaping options are not retained, compared to the DataAware export mode.

Property Paths

You can access this nested property as listed below:

Object Type Path to ExcelExportMode
ASPxGridView
.SettingsExport .ExcelExportMode

Remarks

Use the ExcelExportMode property to specify export mode at design time.

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

Alternatively, you can send the ExportType parameter to an export method at runtime.

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