Manipulate Charts, Pivot tables, and Sparklines using Cloud API

Sparklines in Excel preview

In every new release, we are striving to introduce new features a recent release of Aspose.Cells Cloud 20.9, some new and very exciting features have been introduced so that our customers, make the best use of our APIs while working with Pivot Tables, Charts, and Sparklines within Excel files. Please be aware that you cannot only work with MS Excel files but can also create, update, and manipulate data inside OpenOffice files (ODS).

Sparklines Processing

Sparklines are an amazing approach for displaying statistical data in a compact and more compelling approach and are usually drawn without axes or coordinates. They are used to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Usually, they are positioned near their data for the greatest impact, and also, if we do not have ample space to accommodate a chart, we make use of Sparklines for a better visual representation of data.

Owing to such importance, the capabilities to create as well as manipulate existing sparlines within Excel worksheet has been provided in Aspose.Cells Cloud API.

Working with Pivot tables

A pivot table is an amazing way to store the summary of a certain data set in a condensed manner and also, helps the user to expand, isolate, sum, and group the particular data in real-time. The table helps in making a concise summary out of thousands of rows and columns of unorganized data and enables you to make precise and quick decisions.

Aspose.Cells Cloud is capable of programmatically dealing with Pivot tables and in the recent release version, a specific update has been made to enable the users to update pivot tables in excel worksheet. Therefore, in order to update the style of the pivot table, you need to use PostPivotTableStyle method.

cURL command

curl -X POST "http://api.aspose.com/v3.0/cells/Sample_Pivot_Table_Example.xls/worksheets/Sheet2/pivottables/0/FormatAll" -d '{"Font":{"Name":"Arial", "Size":10}}' -H "Content-Type: application/json" -H "Accept: application/json"

Go

Adding Charts to Excel worksheet

“Pictures express more than words”. Therefore, charts help in summarizing an entire table into an understandable fact where Millions of data points can be charted and results can be seen immediately. Also, it is really very tiring to understand data through large tables. Whereas Charts allow your audience to see the meaning behind the number. Furthermore, in many cases, there are trends or insights that cannot be shown by simply looking at raw data. Aspose.Cells Cloud is fully capable of dealing with charts when it comes to retrieval, addition, update, removal, transformation, or manipulation of Chart instance from an Excel worksheet.

You simply need to use PutWorksheetAddChart method to add chart instance to the excel worksheet.

cURL

curl -X PUT "http://api.aspose.com/v3.0/cells/myWorkbook.xlsx/worksheets/Sheet1/charts?chartType=Bar&area=B1:F2&title=SalesState" -H "Content-Type: application/json" -H "Accept: application/json"

Go

Useful links