Pivot tables are a powerful tool in Excel for summarizing and analyzing data. They allow you to quickly transform a large dataset into a more manageable and meaningful format. In this article, you’ll learn how to create Pivot Table in Excel in C#. Also, we will cover how to sort or hide Pivot Table data programmatically using Aspose.Cells for .NET - a .NET API to create and manipulate Excel spreadsheets without requiring Microsoft Excel.
Embedded Fonts Management support in Aspose.Slides
We are pleased to announce the release of Aspose.Slides for .NET 17.8. This is one of important product releases whereby we have added support for certain long awaiting features along with resolution of incurring issues in API.
Features Following features have been introduced in this release.
Support for embedded fonts. Support for switching Rows and Columns of chart data. Support for getting loaded fonts list from LoadExternalFonts(). Support for setting offset values of stretched picture.
Sitefinity Dynamic Forms Builder with Data Export to Excel, CSV, Text and OpenDocument Spreadsheet using Aspose.Cells for .NET
Aspose.Cells Dynamic Forms for Sitefinity Module allows users to Generate Dynamic Questionnaire and Surveys, save user input into Excel spreadsheets and Export the results into Excel, Text, CSV and OpenDocument Spreadsheet using Aspose.Cells. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells for .NET.
free download video demo open source Features in this Release This initial version of the module is enriched with the following features to make the Forms Building and Export process simple and easy to use
Explore Aspose.Cells for .NET API Examples using Visual Studio Plugin
Visual Studio plugin for Aspose.Cell for .NET code examples is a great tool for quickly downloading and exploring Aspose.Cells for .NET API examples. We are pleased to announce a new release that supports exploring examples of Aspose.Cells for .NET. This plugin saves a lot of time and effort by providing a very simple option for seamlessly selecting, downloading and opening the latest example projects without having to leave the Visual Studio environment.
Generate Dynamic Questionnaire and Surveys and Export Results into Excel, Text, CSV and OpenDocument using Aspose.Cells Forms for DNN
Aspose.Cells Dynamic Forms for DNN Module allows users to Generate Dynamic Questionnaire and Surveys, save user input into Excel spreadsheets and Export the results into Excel, Text, CSV and OpenDocument Spreadsheet using Aspose.Cells. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells for .NET.
free download video demo open source Features in this Release This initial version of the module is enriched with the following features to make the Forms Building and Export process simple and easy to use
Aspose.Cells for .NET VS OpenXML SDK - Deal with Microsoft Excel Documents
We’ve added more examples in the release of the Aspose.Cell for .NET features unavailable in OpenXML Excel SDK. These examples show how different tasks can be performed using Aspose.Cells for .NET APIs in comparison with OpenXML SDK to deal with Microsoft Excel documents. This project is helpful for developers who want to migrate from OpenXML to Aspose or compare OpenXML with Aspose.Cells.
What’s new? Encrypting Excel Files Save Workbook to Text or CSV Format Managing Charts and Shapes Add WordArt Watermark to Chart Add WordArt Watermark to Worksheet Locking WordArt Watermark Copy Shapes between Worksheets Set External Links in Formulas Setting Formula Calculation Mode of Workbook Setting Shared Formula Existing Examples Convert Between Excel Formats Convert between Excel formats High-level Programming with a Workbook Object Model Find and Replace in Spreadsheet Assemble Spreadsheets Copy Fragments and Worksheets between Workbooks Copy Worksheets within a Workbook Copy Worksheets between Workbooks Move Worksheets within Workbook Generate Reports, Populate Documents with Data Import Export data from document Insert or Delete Rows or Columns Smart Markers Features Grouping Data Using Anonymous Types or Custom Objects Image Markers Using Nested Objects Rendering and Printing Convert charts to images Specify image resolution, quality, compression and other options Print spreadsheets Calculate or Recalculate Formulas Dynamically Calculate or Recalculate formulas dynamically Download Latest Examples You can download the latest examples from one of the following locations:
More Code Examples of Aspose.Cells for .NET in Comparison with NPOI HWPF and XWPF
We are pleased to announce another release of Aspose.Cells for NPOI (HWPF and XWPF) which shows how different tasks can be performed using Aspose.Cells .NET APIs in comparison with NPOI. Code Comparison of Aspose Cells for .NET with NPOI is helpful for developers who want to compare NPOI with the easiness and flexibility of Aspose.Cells for .NET OR migrate from NPOI to Aspose.Cells.
What’s New in this Release v 1.1 Below are the features of another release of comparison examples of NPOI with Aspose Cells for .
Calculate the Width and Height of the Cell Value and Get an Array of Values from ICustomFunction using Aspose.Cells for .NET 8.5.1
Aspose.Cells for .NET 8.5.1 has been released. This release contains some useful features and other enhancements along with some critical bug fixes. If you are planning to upgrade the Aspose.Cells for .NET API to the latest revision, we would strongly suggest you to check the complete Public API Changes section to know what has been changed in the API so far. We have provided a few important features in this month’s release.
Retrieve Excel Worksheet Instance from Chart using C#
Aspose.Cells for .NET 8.2.2 has been released. This release contains useful new features and a number of improvements. It introduces contains over 60 improvements, including the new features listed below. If you are planning to upgrade the API from a previous release, we suggest you check the Public API Changes section.
Get Worksheet Instance of the Chart using C# Before the release of Aspose.Cells for .NET 8.2.2, retrieving the Worksheet instance from the Chart object was not possible.
Directly Converting Excel Files to Pdf with Aspose.Cells
In previous versions, converting Excel files to Pdf needs two components: Aspose.Cells and Aspose.Pdf. With the new version v4.7.0, users can use Aspose.Cells for .NET only to implement this feature. This new change greatly optimizes speed and memory usage.
You will utilize the overloaded Save method of the Workbook class providing the SaveFormat.Pdf enum member that converts the native excel file to pdf format.
The above steps are implemented in the following example.