ExportType Enum

Lists the values corresponding to the different export modes available when saving a document to the XLS, XLSX and CSV formats.

Namespace: DevExpress.Export

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum ExportType

VB.NET

Public Enum ExportType

Members

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.

Related API Members

The following properties accept/return ExportType values:

Library	Related API Members
Cross-Platform Class Library	CsvExportOptionsEx.ExportType
	ExportSettings.DefaultExportType
	XlsExportOptionsEx.ExportType
	XlsxExportOptionsEx.ExportType
ASP.NET Web Forms Controls	ASPxCardViewExportSettings.ExcelExportMode
	ASPxGridExportSettings.ExcelExportMode
	MVCxCardViewExportSettings.ExcelExportMode
	MVCxGridExportSettings.ExcelExportMode

Remarks

An ExportType enumeration value is used to set the ExportSettings.DefaultExportType, CsvExportOptionsEx.ExportType, XlsExportOptionsEx.ExportType and XlsxExportOptionsEx.ExportType properties.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ExportType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-export-colored-gridview-t334596/CS/Controllers/HomeController.cs#L23

XlsxExportOptionsEx exportOptions = new XlsxExportOptionsEx();
exportOptions.ExportType = DevExpress.Export.ExportType.WYSIWYG;
return GridViewExtension.ExportToXlsx(GridViewHelper.ExportGridViewSettings, MyModel.GetProducts(), exportOptions);

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/CS/GridDataAwareExportCustomization/Form1.cs#L40

// Ensure that the data-aware export mode is enabled.
ExportSettings.DefaultExportType = ExportType.DataAware;
// Create a new object defining how a document is exported to the XLSX format.

mvc-pivot-grid-custom-export/CS/MVCxPivotGrid_CustomExport/Controllers/HomeController.cs#L30

PivotXlsxExportOptions options = new PivotXlsxExportOptions();
options.ExportType = DevExpress.Export.ExportType.WYSIWYG;
return PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, Models.NwindModel.GetData(), options);

VB.NET

how-to-export-colored-gridview-t334596/VB/Controllers/HomeController.vb#L25

Dim exportOptions As New XlsxExportOptionsEx()
exportOptions.ExportType = DevExpress.Export.ExportType.WYSIWYG
Return GridViewExtension.ExportToXlsx(GridViewHelper.ExportGridViewSettings, MyModel.GetProducts(), exportOptions)

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/VB/GridDataAwareExportCustomization/Form1.vb#L43

' Ensure that the data-aware export mode is enabled.
ExportSettings.DefaultExportType = ExportType.DataAware
' Create a new object defining how a document is exported to the XLSX format.