Example of Export as Pivot in ASP.NET Core Pivot Table Control

This sample shows how to export a server-side Syncfusion Pivot Table to an Excel file while preserving its native pivot structure. The exported Excel file supports full interactivity, allowing users to customize pivot configurations directly within Excel.

The Pivot Table uses a server-side pivot engine powered by the Syncfusion.Pivot.Engine package. This engine runs on a separate hosted server, performing all pivot operations—including Aggregation, Filtering, Sorting, and Grouping and returns only paged data to the client. The connection to the remote service is configured using the dataSourceSettings->url property.

Excel Export is available via the built-in toolbar and generates a true Excel Pivot Table, not just static data. This enables users to interact with and manipulate the exported report directly in Excel.

Additionally, the toolbar includes custom menu items to toggle between Compact and Tabular layouts and to switch chart types dynamically. This empowers users to customize both the visual structure and the associated chart representation of their data.

More information about server-side aggregation can be found in this documentation section .