ContextQMD
Back to Devexpress

Export to Excel

windowsforms-404047-controls-and-libraries-tree-list-feature-center-export-to-xls-xlsx-csv.md

latest1.4 KB
Original Source

Export to Excel

  • Aug 20, 2022

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.