Articles in this section
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);
 

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment