Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Export to Excel

The TreeList control supports Data-Aware and WYSIWYG export modes. These modes export data in XLS, XLSX, and CSV formats.

Use the static DefaultExportType property to specify the export mode when you use the ExportToXls, ExportToXlsx, and ExportToCsv methods.

In Data-Aware mode, the TreeList control exports data faster and uses less memory. This mode exports all data shaping options (for example, collapsed/expanded state, summary formulas, and format rules). The layout of UI elements may not match the original layout in the exported document.

WYSIWYG mode retains the layout of UI elements in the output document. This mode does not retain the data shaping options. For instance, the TreeList exports summary values as text strings rather than formulas.

The WinForms Grid and TreeList controls use the same data export mechanism. See the following Data Grid topic for detailed information: Export to XLS, XLSX, CSV Formats.