Export Overview

• Dec 17, 2020

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:

Output Format	Method	Export Settings Passed to the Method
HTML	PivotGridExtension.ExportToHtml	PivotGridSettings, HtmlExportOptions
MHT	PivotGridExtension.ExportToMht	PivotGridSettings, MhtExportOptions
PDF	PivotGridExtension.ExportToPdf	PivotGridSettings, PdfExportOptions
RTF	PivotGridExtension.ExportToRtf	PivotGridSettings, RtfExportOptions
TXT	PivotGridExtension.ExportToText	PivotGridSettings, TextExportOptions
CSV	PivotGridExtension.ExportToCsv	PivotGridSettings, CsvExportOptions
XLS	PivotGridExtension.ExportToXls	PivotGridSettings, XlsExportOptions, PivotXlsExportOptions
XLSX	PivotGridExtension.ExportToXlsx	PivotGridSettings, XlsxExportOptions, PivotXlsxExportOptions

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.