This demo demonstrates how to easily export data in WYSIWYG (What You See Is What You Get) or Data-Aware modes. Data can be exported to a file or stream in the following formats:
However, exporting to table formats (XLS, XLSX, and CSV) is performed in Data-Aware mode by default. You can specify the default mode for all methods exported to the Excel format or for each of them. To change the default mode for all methods that support DataAware, use the ExportSettings.DefaultExportType property. To change an export type with each call, create an XlsExportOptionsEx object (or XlsxExportOptionsEx, CsvExportOptionsEx objects), set its ExportType property to the ExportType.DataAware or ExportType.WYSIWYG value and pass this object to the ExportTo... method.
To export ASPxPivotGrid data, create an ASPxPivotGridExporter control instance in addition to ASPxPivotGrid and assign ASPxPivotGrid's ID to the ASPxPivotGridExporter.ASPxPivotGridID property value.