Pivot Export Demo

This sample illustrates the use of Exporting PivotGrid into Excel, Word and PDF formats.

Features

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);

Here is the Exported Image:

ToolTip Demo

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);

Here is the Exported Image

Pivot Export Demo

Excel Export

Here we have support for converting the Pivot Grid to Two excel document types:

  • Excel Export of Pivot Type
  • Excel Export of Cell Type

    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.

    Pivot Export Demo

    Excel Export Of Cell- Based type:

    This enables you to convert the PivotGrid to excel of Cell Type.

    Pivot Export Demo