This sample illustrates the use of Exporting PivotGrid into Excel, Word and PDF formats.
PDF Export
This enables you to convert the PivotGrid to Pdf document.Here is a code Snippet:
PivotPdfExport pdfExport = new PivotPdfExport(pivotGridControl1);
pdfExport.Export(FileName);
Word Export
This enables you to convert the PivotGrid to Word Document.Here is a short code Snippet:
PivotWordExport wordExport = new PivotWordExport(); wordExport.pivotGridToWord(FileName, pivotGridControl1);
Excel Export
Here we have support for converting the Pivot Grid to Two excel document types:
Here is a short code Snippet:
ExcelExport excelExport = new ExcelExport(pivotGridControl1, Syncfusion.XlsIO.ExcelVersion.Excel2010); excelExport.ExportMode = (ExportAsPivotTable) ? ExportModes.PivotTable : ExportModes.Cell; excelExport.Export(FileName);
Excel Export into Pivot Table:
This enables you to convert the PivotGrid to excel of Pivot Table.
Excel Export Of Cell- Based type:
This enables you to convert the PivotGrid to excel of Cell Type.