Example of Pivot Table in ASP.NET Core Excel (XlsIO) Library

This sample demonstrates how to use PivotTable in spreadsheets using XlsIO.

Click the "Create Document" button to view the created Excel document and click the "Customize Pivot Table" button to view the Excel document created with customized pivot table. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.



When there is a need to summarize large reports, Excel allows you to summarize data through pivot table insertion. Microsoft Excel supplies various built-in styles for pivot tables, allowing the creation of pivot tables with rich formats and more flexibility in summarizing reports.


  • Creating pivot tables from template data
  • Customizing pivot tables with various properties
  • Formatting pivot tables with built-in styles

Transform your ASP.NET Core web apps today with Syncfusion ASP.NET Core components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing