Exports a grid to the specified stream in XLSX format.
The Print Preview window allows you to customize the printed document, print or export it to a file in the required format. The image below illustrates the Print Preview window for a sample grid.
See the Printing Options section of the Printing topic to learn how to specify the View elements to be printed.
Export to XLS, XLSX, and CSV Formats
This is the default export mode, optimized for subsequent analysis of grid data within Microsoft Excel. Output documents retain various data shaping options that are applied within the grid. The data-aware export functionality provides improved performance and memory usage.
Currently CardView does not support the data-aware export.
The GridControl supports the following features for all Excel export operations:
Data Grouping - allows end users to collapse/expand groups within a worksheet.
Data Sorting and Filtering - allows end users to display relevant data in the desired order.