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

This sample demonstrates how to layout pivot table using XlsIO.

DEMO

SOURCE

Choose the pivot table layout and file format type, then click the "Create Document" button to view the document in Excel or PDF. A PDF viewer is required to view the PDF document, and an Excel viewer is required to view the Excel document.

Layout options

File type XLSX PDF

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:

Create and layout pivot table from template data
Format pivot table cells with cell styles
Convert pivot table to PDF