Add a WinForms Pivot Table to your .NET Application

Spread.NET helps you create spreadsheets, grids, dashboards, and forms. It includes a powerful calculation engine with 450+ functions and the ability to import and export Excel spreadsheets. Leverage the extensive .NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz demonstrates how to build a Pivot Table using the Spread.NET WinForms component, enabling your users to quickly analyze large datasets with the ability to summarize, group, and reorganize data. Creating the Pivot Table includes the following steps:

• Create a PivotCache
• Create the Pivot Table
• Access the PivotFields Collection
• Add the Values Field
• Configure the Row Fields
• Configure the Column Fields
• Add a Filter Field

Detailed source code and sample data are included to assist you along the way.

Read the complete blog post to learn how to integrate a spreadsheet component into your .NET applications and provide your users with familiar spreadsheet functionality without referring them to an external program.

Spread.NET is licensed per developer and is available as either a Perpetual or Annual license, depending upon geographic location. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.