Category / Section
How to Export Pivot Grid to Excel using export mode to cell
1 min read
We have implemented the property “IncludeRowColumnHeaders” that have to set as “True” to export the PivotColumn and PivotRow’s header along with the PivotGrid in Cell mode. (This property “IncludeRowColumnHeaders” is in GridExcelExport class)
C#
GridExcelExport excelExport = new GridExcelExport(this.Target, Syncfusion.XlsIO.ExcelVersion.Excel2007); excelExport.ExportMode = (ExportAsPivotTable) ? ExportModes.PivotTable : ExportModes.Cell; excelExport.IncludeRowColumnHeaders = true; excelExport.Export(savedialog.FileName);