Certain DevExpress controls support two modes (export engines) for data export to XLS(x) and CSV formats. Use the static DefaultExportType property to specify the default export mode for these controls.
Data-aware mode - The new export engine that features improved performance and memory usage. It is optimized for subsequent analysis of exported data. The layout of control elements may not be retained in the export document. Multiple events and options in data-aware export mode give you flexibility for output document customization.
When exporting to MS Excel format, various data shaping options that exist in an exported control (e.g., data grouping, summaries, format rules) will persist in the output XLS-XLSX document. When exporting to CSV, the data shaping options (group rows, summaries, etc.) and item indentation are not retained in the output document.
WYSIWYG mode - In this export mode, the layout of control elements and all display text is retained in the output document. Text items/cells are indented in the output document according to the layout of elements in the exported control. Thus, when exporting to CSV in WYSIWYG mode, the resulting document contains all text data, summary values, group rows, etc., indented if necessary.
To export data in data-aware or WYSIWYG mode, use the ExportToXls, ExportToXlsx and ExportToCsv methods an exported control provides.
Other approaches of exporting controls to XLS(x) and CSV formats (e.g., using the PrintableComponentLink and Reporting Library) employ the WYSIWYG export engine and do not support data-aware export mode.
The supported controls provide the ExportToXls, ExportToXlsx and ExportToCsv method overloads that have the options parameter.
Using these overloads, you can explicitly specify the export mode and customize export behavior for a specific method call.
Initialize the options parameter with the following class objects: