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

This sample demonstrates how to use PivotTable in spreadsheets using Excel (XlsIO) Library.

DEMO

SOURCE

Click the "Create Document" button to view the created Excel document and "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.

Page Filter : Page Filter Multiple Page Filter

Row and Column Filter : Row Filter Column Filter

Apply Grouping

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.

Features:

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