.NET Excel Library - Excel Pivot Tables in C#
- Create, read, and edit pivot tables.
- Apply 84 built-in pivot table styles.
- Customize the pivot table with multiple pivot options.
Try C# Excel Examples in Playground app.
FREE TRIALNo credit card required.
Explore ExamplesNo credit card required.
Trusted by the worldโs leading companies
.NET excel library pivot table
Overview
The Syncfusion .NET Excel Library (XlsIO) supports the creation and manipulation of pivot tables. Use pivot tables to organize, summarize, or calculate data dynamically. These functionalities can be achieved using just a few lines of code.
Pivot table code example
This example code shows how to create a pivot table in Excel using the Syncfusion .NET Excel Library with just a few lines of code in C#.
Key features of pivot tables
Discover how pivot table features in the Syncfusion Excel Library allow you to summarize, analyze, and organize data dynamically, enabling powerful data insights and streamlined reporting in Excel.
Styles and Formatting
Enhance your pivot table with various built-in styles to improve visual appeal and interpretation of data. You can also format individual cells to emphasize key metrics by adjusting font styles, colors, borders, and number formats, ensuring clarity and readability in your presentations.
Layout
Customize the layout of your pivot table to enhance readability and organization. You can choose from several layout types, including compact, tabular, outline, and classic layouts, to suit your analysis needs. Rearrange fields and adjust the display of data to optimize the presentation of your information.
Refresh
Easily refresh your pivot table to update the data it displays. This ensures that any changes made to the source data are reflected in your pivot table, allowing for accurate and current insights.
Sorting and Filtering
Utilize sorting and filtering features within your Pivot Table to organize data effectively. You can sort information to highlight key metrics and apply filters to focus on specific data points, making analysis more manageable.
Group by Time Range
Group data in your pivot table to aggregate information meaningfully. This allows you to organize data by time periods, facilitating deeper analysis and clearer presentation of results.
Expand and Collapse
You can expand or collapse data in your pivot table to focus on specific details or to get an overview of the information. This feature enhances your data exploration by allowing you to navigate through different levels of data granularity easily.
Pivot table references
Discover valuable resources from our blog and knowledge base to enhance your efficiency in using pivot tables.
๐ Easily Create an Excel Pivot Table in Just 3 Steps Using C#
Blog
Easily Create an Excel Pivot Table in Just 3 Steps Using C#
๐ How to create a pivot table in an Excel document using C#, VB.NET
Knowledge base
How to create a pivot table in an Excel document using C#VB.NET
๐ How to refresh an Excel pivot chart in C#,VB.NET
Knowledge base
How to refresh an Excel pivot chart in C#VB.NET
๐ How to sort Excel pivot table data by row and column fields in C#, VB.NET
Knowledge base
How to sort Excel pivot table data by row and column fields in C#VB.NET
๐ How to set custom formatting in the data fields of a pivot table in C#, VB.NET
Knowledge base
How to set custom formatting in the data fields of a pivot table in C#VB.NET
๐ How to create a pivot table in an Excel workbook with data exported
Knowledge base
How to create a pivot table in an Excel workbook with data exported using template markers in C#
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Frequently Asked Questions
Can I edit and format a pivot table using the Syncfusion Excel Library?
Yes, the Syncfusion Excel Library allows you to edit and format pivot tables. You can customize pivot table formatting and pivot cell formatting to enhance the appearance of your pivot tables.
Can I expand or collapse rows in a pivot table using the Syncfusion Excel Library?
Yes. Syncfusion Excel library allows you to expand or collapse rows in your pivot table effortlessly. This feature enables you to control the level of detail displayed, facilitating focused analysis on specific data points within your pivot table.
Can I apply sorting to a pivot table using the Syncfusion Excel Library?
Yes, you can apply sorting to pivot tables using the Syncfusion Excel Library. The library enables you to sort pivot table fields both top to bottom and left to right.
Is it possible to apply a pivot table layout using the Syncfusion Excel Library?
Yes. The Syncfusion Excel Library allows you to apply various layout options for pivot tables. You can choose a compact layout, outline layout, or tabular layout.
Can I apply pivot table filters using the Syncfusion Excel Library?
Yes, you can apply pivot table filters using the Syncfusion Excel Library. The library supports two types of filters: page filters and row/column filters. You can easily apply these filters to manipulate the data displayed within the pivot table.
Can I group date and time fields in a pivot table using the Syncfusion Excel Library?
Yes, you can group date and time fields in a pivot table using the Syncfusion Excel Library. It supports grouping pivot data based on various categories including date, month, year, quarters, hours, minutes, and seconds. This feature empowers you to organize and analyze your data efficiently based on different time-related intervals.
Our Customers Love Us
Here are some of their experiences.
See Real Success Stories
Developers around the world trust Syncfusionโs Essential Studio to simplify complex projects and speed up delivery. With a vast library of UI controls, powerful SDKs, and reliable support, Essential Studio helps teams build enterprise-ready applications with confidence.
Read Our Customer StoriesIndustry
Software development
75% Cost reduction
50% Faster development
โIf somebody is looking for a great tool to work with? Yes. I would definitely recommend Syncfusion for anyone who is trying to develop something meaningful.โ
- Somnath Maji (Founder of Igniatek Consultancy)
Read StoryIndustry
Utilities (oil and gas)
Advanced, flexible features
Empowered users through robust and versatile functionality.
โSyncfusionโs tools have taken care of many things so I can focus on developing the application, instead of developing tools for the application.โ
- James Athyal (Software developer, McDaniel & Associates Consultants Ltd)
Read StoryIndustry
Software and technology
Efficient file management
Streamlined workflows with document libraries without building them from scratch.
โWe really love when the magic happens.โ
- Irvin Dominin (BUILDER WEB Development Manager at Sistemi)
Read StoryIndustry
Software and technology
โWe are Syncfusion fans because of the way Syncfusion treats the support.โ
- Dr. Howard Rybko (CEO of Synchrony Digital)
Read StoryIndustry
IT services and IT consulting
Improved performance
Large datasets handled with easy customization and quick debugging.
Highly customizable
Plug-and-play controls with quick template integration.
โI will surely recommend Syncfusion to others as a third-party control because I think itโs very easily customizable.โ
- Jayesh (Technical Team Lead, Capita)
Read StoryIndustry
Professional services
โWe definitely wanted Syncfusion to help us with our document processing functionality, and we were happy with and satisfied with Syncfusion.โ
- Arvind Naik (Engineering Lead, Vialto Partners)
Read StoryRated by users across the globe
Want to create, View, and edit Excel files in C# or VB.NET?
No credit card required.
Awards
Greatnessโitโs one thing to say you have it, but it means more when others recognize it. Syncfusionยฎ is proud to hold the following industry awards.
