Delete All Worksheet Validations – Aspose.Cells Cloud API

Prerequisites

A valid Aspose Cloud account.
A JWT access token obtained via the Aspose Cloud authentication API (/connect/token).
The workbook must be stored in your Aspose Cloud storage (or the appropriate folder/storageName query parameters must be provided).

This REST API deletes all worksheet validations on an Excel worksheet.

REST API

DELETE http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/validations

Request parameters

Parameter Name	Type	Location	Description
name	string	path	The name of the Excel document.
sheetName	string	path	The name of the worksheet containing the validations.
folder	string	query	The folder where the document is stored.
storageName	string	query	The name of the storage service.

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

You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to call the API with cURL after obtaining a JWT token.

Request

curl -v "http://api.aspose.cloud/v3.0/cells/myWorkBook.xlsx/worksheets/Sheet1/validations" \
  -X DELETE \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>"

Response

{
  "Code": 200,
  "Status": "OK"
}

Error Handling

HTTP Status	Meaning	Description
400	Bad Request	The request is malformed or missing required parameters.
401	Unauthorized	The JWT token is missing, invalid, or expired.
404	Not Found	The specified workbook or worksheet does not exist.
500	Internal Server Error	An unexpected error occurred on the server side.

The error payload follows the same JSON structure with Code and Message fields, for example:

{
  "Code": 401,
  "Message": "Invalid or expired token."
}

Cloud SDK Family

Using an SDK is the fastest way to develop. An SDK abstracts low‑level details so you can focus on business logic. Please check the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to call Aspose.Cells web services using various SDKs: