How to export Pivot Grid to excel using export mode to cell?
We have implemented the property “IncludeRowColumnHeaders” that have to set as “True” to export the PivotColumn and PivotRow’s header along with the WPF 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);
Conclusion
I hope you enjoyed learning about how to export Pivot Grid to Excel using export mode to cell.
You can refer to our WPF PivotGrid feature tour page to know about its other groundbreaking feature representations. You can also explore our WPF PivotGrid to understand how to present and manipulate data.
For current customers, you can check out our WPF Controls from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our WPF PivotGrid and other WPF controls.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!