Spreadsheet Cloud API: postWorksheetPivotTableCalculate

Calculate pivottable's data to cells.

Quick Start

• Base URL: http://api.aspose.cloud/v3.0
• Authentication Method: JWT (OAuth2, application) Token URL: https://api.aspose.cloud/connect/token
• Example

Interface Details

Endpoint

POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Calculate

Function Description

PageTitle: Calculate pivottable's data to cells.PageDescription: Aspose.Cells Cloud provides robust support for calculating pivottable's data to cells, a process known for its intricacy.HeadTitle: Calculate pivottable's data to cells.HeadSummary: Aspose.Cells Cloud provides robust support for calculating pivottable's data to cells, a process known for its intricacy.HeadContent: Aspose.Cells Cloud provides REST API which supports calculating pivottable's data to cells and offers SDKs for multiple programming languages. These programming languages are include of Net, Java, Go, NodeJS, Python, and so on.

The request parameters of postWorksheetPivotTableCalculate API are:

| Parameter Name | Type | Path/Query String/HTTPBody | Description | | :- | :- | :- |:- | |name|String|Path|The file name.| |sheetName|String|Path|The worksheet name.| |pivotTableIndex|Integer|Path|Gets the PivotTable report by index.| |folder|String|Query|The folder where the file is situated.| |storageName|String|Query|The storage name where the file is situated.|

Response Description

{
  "Name": "CellsCloudResponse",
  "Type": "Class",
  "IsAbstract": false,
  "Properties": [
    {
      "Name": "Code",
      "Nullable": true,
      "ReadOnly": false,
      "IsInherit": false,
      "DataType": {
        "Identifier": "Integer",
        "Name": "integer"
      }
    },
    {
      "Name": "Status",
      "Nullable": true,
      "ReadOnly": false,
      "IsInherit": false,
      "DataType": {
        "Identifier": "String",
        "Name": "string"
      }
    }
  ]
}

OpenAPI Specification

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

[Back to API list]
[Back to README]