Export Overview
In This Article
The Pivot Grid allows you to export the MVCxPivotGrid’s data to a file or stream in PDF, CSV, XLS or XLSX, HTML, MHT, RTF, and TXT formats.
#Export API
You can use methods listed in the following table to export Pivot Grid to different formats:
#Limitations
The following content is not exported:
- field and cell templates
- customized styles
- HtmlTextWriter output produced in event handlers.
#Export Modes
There are two different modes - WYSIWYG and Data Aware - used to export MVCXPivotGrid to the XLS, XLSX and CSV formats. To select a mode, use the ExportType enumeration to specify the export mode in export options.
Refer to the Export to Tabular Formats (CSV, XLS, XLSX) article for more information.