Export

You can export pivot data to Microsoft Excel. The exported data interaction is enabled in the Excel.

  • c#
  • ExcelExport excelExport = new ExcelExport(this.pivotChart1, Syncfusion.XlsIO.ExcelVersion.Excel2010, Syncfusion.XlsIO.ExcelChartType.Column_Clustered);
    
                excelExport.Export(saveDialog.FileName);
  • vbnet
  • Dim excelExport As New ExcelExport(Me.pivotChart1, Syncfusion.XlsIO.ExcelVersion.Excel2010, Syncfusion.XlsIO.ExcelChartType.Column_Clustered)
    
    excelExport.Export(saveDialog.FileName)

    Sample: <InstalledLocation>\Syncfusion\EssentialStudio<InstalledVersion>\Windows\PivotChart.Windows\Samples\Exporting\PivotChartExport Demo\CS