ASPxGridViewExportSettings.ExcelExportMode Property
Specifies the export mode when saving grid data to XLS and XLSX formats.
Namespace: DevExpress.Web
Assembly: DevExpress.Web.v24.2.dll
NuGet Package: DevExpress.Web
#Declaration
[DefaultValue(ExportType.Default)]
public ExportType ExcelExportMode { get; set; }
#Property Value
Type | Default | Description |
---|---|---|
Export |
Default | The export mode. |
Available values:
Name | Description |
---|---|
Default | The default export mode. For the Export If the Xlsx |
Data |
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. The layout of control elements may not be retained in the export document. Other limitations also apply. Not all controls support the Data |
WYSIWYG | Export type that uses the export engine of the Xtra |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Excel |
---|---|
ASPx |
|
#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 });