Working with Excel PivotTables – Aspose.Cells Cloud Documentation
Contents
[
Hide
]
Working with PivotTables on an Excel file
PivotTables are powerful data‑summarization tools in Excel that let developers dynamically aggregate, filter, and analyze large data sets. The Aspose.Cells Cloud API provides endpoints to create, retrieve, modify, and delete PivotTables programmatically, enabling seamless integration into your applications.
Prerequisites – You must have a valid Aspose.Cells Cloud authentication token and a supported SDK (e.g., .NET, Java, Python, Go, Node.js, PHP, Ruby, Swift) installed in your project.
Example API call – To retrieve all PivotTables in a specific worksheet, send a GET request such as:
GET https://api.aspose.cloud/v3.0/cells/{fileName}/worksheets/{sheetName}/pivottables
Notes – These operations require Aspose.Cells Cloud version 3.0 or later.
- How to get PivotTable information from an Excel worksheet.
- How to get PivotTable information by index from an Excel worksheet.
- How to add a PivotTable in a worksheet.
- How to add a PivotField into a PivotTable.
- How to delete all PivotTables from an Excel worksheet.
- How to delete a PivotTable by index from an Excel worksheet.
- How to update cell style for a PivotTable.
- How to update style for all PivotTables.
- How to add filters to a PivotTable.
- How to hide a PivotField item in a PivotTable.
- How to move a PivotTable on an Excel worksheet.
- How to work with the CellsObjectOperate task.
- How to convert a list object to a PivotTable.