Manipulate Pivot Tables and Pivot Fields, Retrieve Workbook Settings and Import bulk of data in worksheet with single call using Aspose.Cells Cloud APIs

Aspose.Cells Cloud is a REST API that helps you create, manipulate and convert spreadsheets in the cloud. It allows you to work with all aspects of spreadsheets: worksheets, rows, columns, cells, text, data, images, links, comments, formulas, charts, and many more. Use Aspose.Cells Cloud to create spreadsheets from scratch, manipulate spreadsheets, and convert spreadsheets to other formats. Render a spreadsheet to image formats such as JPEG, PNG, SVG, GIF and TIFF, or render charts and other objects to images.

Aspose.Cells Cloud’s platform independent document manipulation API is a true REST API that can be used with any language: .NET, Java, PHP, Ruby, Rails, Python, jQuery and many more. You can use it with any language or platform that supports REST. (Almost all platforms and languages support REST and provide native REST clients to work with REST APIs). You do not need to worry about language or platform limitations. You can use it with any platform — web, desktop, mobile, and cloud. The API integrates with other cloud services to give you the flexibility you need when working with spreadsheets and data. Learn More

We are pleased to announce the release of Aspose.Cells Cloud 1.2.0 with following features and improvements.

Manipulate Pivot Tables and Pivot Fields

Aspose.Cells Cloud now allows you to work with pivot tables.  Now you can get the information of all the pivot tables or individual pivot table inside the worksheet in cloud environment. You can add new pivot table inside the worksheet and add new pivot fields or get information of existing pivot fields in a pivot table.  Also now you can update the style of individual cell of the pivot table or entire pivot table.

The following Aspose.Cells Cloud REST API resources deal with pivot tables and pivot fields.

Retrieve Workbook Settings

Aspose.Cells Cloud now also supports to retrieve the settings defined inside the workbook. The workbook settings provide a number of useful information relating to workbook like auto compress pictures, auto recover, build version, calculation mode, calculation stack size and id, display drawing objects, enable macros, first visible tab, hide pivot field list, is vertical scroll bar visible, language code, parsing formula on open, recalculate on open, recalculate before save, region, window height etc.

Import or Transfer bulk of data in a worksheet with single call

With this release, you can import or transfer bulk of data in a worksheet with single call. The import data option allows you import integer, string, double, 2-dimension integer, string and double array. Also, you can import batch of data with mixed cell values and types in a single call using the import batch data option.

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.