Create PivotTable & Convert Excel Table to a Normal Range of Cells in Cloud Apps

2024-11-01 05:19:52 Computer

736

We are pleased to announce the new release of Aspose.Cells for Cloud 17.2.0. Developers can sign up in Aspose Cloud UI account, get the security codes (AppSID and AppKey) of an application, and then use Aspose.Cells for 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 for Cloud API also works with both desktops and mobile devices, no matter what operating system clients are using. 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. Aspose.Cells for Cloud API now supports pivot table operations in asynchronous processing through the CellsObjectOperate Task object. CellsObjectOperate Task now accepts PivotTableOperateParameter to perform operations. Aspose.Cells for 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. A Pivot Table is the great feature within Excel as it allows to analyze data in many different ways. Using Aspose.Cells for Cloud API, developers can create a pivot table to summarize the list objects data. It helps in reviewing the overall totals. Using Aspose.Cells for 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. Following are the important features and enhancements included in this release.

? Support Pivot Table Filters
? Support Pivot Table operation in Task processing
? Add recalculate parameter for hiding pivot field item
? List object - Convert to range
? List object - Summarize with Pivot Table
? Move Pivot Table
? Move Pivot Table field

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

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. Users can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

More about Aspose for Cloud

- Learn More about Aspose.Cells for Cloud: http://www.aspose.com/products/cells/cloud

- Download Aspose.Cells for Cloud: http://www.aspose.com/downloads/cells/cloud

- Aspose.Cells for Cloud Documentation: http://www.aspose.com/docs/display/cellscloud/Home

- Ask technical questions/queries from Aspose for Cloud Support Team: http://www.aspose.com/community/forums/default.aspx?GroupID=15

Contact Information
Aspose Pty Ltd, Suite 163,
79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465