Create Pivot Table to Summarize Data, Apply Pivot Filters, Convert List Objects or Table to Range and Recalculate Pivot Table Data on Cloud

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose Cells for CloudWe’re pleased to announce the availability of new version 17.02.0 of Aspose.Cells Cloud API. Developers can sign up in Aspose Cloud UI account, get the security codes (AppSID and AppKey) of an application, and then use Aspose.Cells Cloud RESTful API with any language that has support of HTTP. Developers may also use any available language-specific SDK to convert, edit, or manipulate Microsoft Excel Workbooks. It would save time in organizing and analyzing large amounts of data in an efficient way. Aspose.Cells Cloud API also works with both desktops and mobile devices, no matter what operating system clients are using. The recent version 17.02.0 has added new features. Let’s go into more details of each feature one by one.

Retrieve, Delete or Apply Filters to a Pivot Table

To focus on the smaller portion of a large amount of pivot table data, users can filter the data in Microsoft Office Excel. There are several ways to do that. Using Aspose.Cells API, developers can work with filters of any pivot table programmatically. They can apply a new filter to a pivot table, retrieve all filters of a pivot table or delete a filter of any pivot table. The help topic and resource API explain how to work with filters of a PivotTable: Working with Pivot Filters 

Pivot Table Operations using CellsObjectOperate Task 

Aspose.Cells Cloud API now supports pivot table operations in asynchronous processing through the CellsObjectOperate Task object. CellsObjectOperate Task now accepts PivotTableOperateParameter to perform operations. This help topic explains how to work with pivot table using CellsObjectOperate Task: Working with Pivot Table using CellsObjectOperate Task

Converting ListObjects or Table to a Normal Range of Cells

Aspose.Cells Cloud API now supports converting the ListObjects or an Excel table to a normal range of cells. All formatting and values will be the same. This help topic explains how to convert ListObjects or a table to the normal range of cells: Convert List  Object or Table to a Range

Create a Pivot Table to Summarize ListObjects Data

A Pivot Table is the great feature within Excel as it allows to analyze data in many different ways. Using Aspose.Cells Cloud API, developers can create a pivot table to summarize the list objects data. It helps in reviewing the overall totals. This help topic explains how to summarize list objects data in a single pivot table: Create a new Pivot Table with List Object as Source Data

Hiding Pivot Field Item and Recalculate Pivot Table Data

Using Aspose.Cells Cloud API, developers can change the visibility of a pivot field item, and then recalculate overall pivot table data. This help topic shows how to hide a pivot field item, and the recalculation: Recalculate Pivot Table after Hiding Pivot Field Item

Aspose.Cells Cloud Resources

Following are the links to some useful resources you may need to accomplish your tasks.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with the Aspose Cloud service. Once you have signed up, you are ready to try the powerful file processing features offered by Aspose Cloud.